SQL & PL/SQL

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!

Compare data of same column

AyhamMay 18 2012 — edited May 18 2012

Hi all,
How can i compare and get the simalarties of data in same column.

the is the example two columns one is Name and another is Value

Name value
Cairo 1
Cairo 4
Cairo 6
KL 1
KL 2
KL 6

i want to retrive the cities that has same values as general as we noticed that
cairo has 1 and cairo alsi has 6 and Kl has 1 and 6 so we can say that cairo match kl

the question is how can i compare data in same column and retrive only data that are matched

thanks

Edited by: Yafooz on May 18, 2012 10:39 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 15 2012

Added on May 18 2012

12 comments

3,509 views