How to find the duplicate values in the same row

Question

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.

Refer: stackoverflow.com/a/14990842/2142994

Ani Menon
– Ani Menon

2016-06-20 07:36:08 +00:00
Commented Jun 20, 2016 at 7:36 — Ani Menon
– Ani Menon, Commented Jun 20, 2016 at 7:36

ScaisEdge · Accepted Answer · 2016-06-20 07:30:38Z

3

You can use LIKE

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

answered Jun 20, 2016 at 7:30

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Felix D. Over a year ago

@scaisEdge glad it works, can you try to explain what exactly this is doing ?

ScaisEdge Over a year ago

@Nudity .. sure .. simply the query looking for the row where the column ADR_Address end with the same value in the column ADR_Nr the like operator look for the value .. the % ignore all the character before the ADR_Nr value ..the || operator join the wildcard % and the column value ADR_Nr.. hope is clear ..

Collectives™ on Stack Overflow

How to find the duplicate values in the same row

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related