CODEWITHSUNDEEP
sqloracle-database
Vishnu Prabhu
Vishnu Prabhu

Reputation: 51

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.

Upvotes: 3

Views: 77

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133400

You can use LIKE 

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

Upvotes: 3

Related Questions