Vishnu Prabhu Vishnu Prabhu - 1 year ago 40
SQL Question

How to find the duplicate values in the same row

I needed to find the duplicate in the same row.

I have problem like this ADR_Address ADR_Nr
1 Rudolf-Street- 8 8
2 Maxstresst-10 10

So you can see the
has the house
two times.

My task it to find this kind of duplicate values.

Could any one can help me to find using Oracle SQL Statement.

Answer Source

You can use LIKE

select * from my_table 
where ADR_Address like '%' ||ADR_Nr