Vishnu Prabhu Vishnu Prabhu -5 years ago 103
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
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download