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!

How to find duplicate records in translation table?

967367Apr 10 2015 — edited Apr 10 2015

Hi Team,

I have a translation table with US and Chinese languages. there are total 600 records in each language. but there is a difference in the distinct records count for each language. US language has 550 distinct records rather Chinese has only 540 records. how can i query to find out extra 10 duplicates of Chinese language?

FYI.. We have Primary key column with 1 to 600 values to differentiate the each record with other.

Thanks in advance for the help

Poli

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2015

Added on Apr 10 2015

1 comment

276 views