Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Avoid Vice versa duplicate Data from table

2932473Mar 8 2016 — edited Mar 9 2016

Hi All,

I have a issue with a table while extracting the data, this table consists of duplicate data but in a vice versa Manner( PFA Image for better understanding), i mean two lines of data in the table. But i want only row for data for each duplicate. Kindly suggest best logic or approach to solve this. Thanks in Advance !!

Issue.JPG

Regards

Jeyaprakash

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 6 2016
Added on Mar 8 2016
#sql-developer
2 comments
370 views