Vishnu Prabhu Vishnu Prabhu - 5 months ago 7
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

S.no ADR_Address ADR_Nr
1 Rudolf-Street- 8 8
2 Maxstresst-10 10


So you can see the
ADR_Address
and
ADR_Nr
has the house
Nr
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

You can use LIKE

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