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!

Unique occurence of values

710419Sep 1 2009 — edited Sep 1 2009

Hi and thank you for reading,

I have currently a table with the three columns continent, country, city, but the occurrence of a city is not unique in the table, so it looks like this:

NA USA NYC
SA Brasil San Paolo
EUR France Paris
EUR Germany Berlin
NA USA NYC
...

I would like to construct a table, which reduces the occurrence of each city to only once. How can I do that?

Thanks a lot for your help!

Evgeny

This post has been answered by 673860 on Sep 1 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2009

Added on Sep 1 2009

5 comments

281 views