Skip to Main Content

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!

Query to display distinct rows based on Key columns

srikanth bJun 5 2021

Hi everyone,
I have two unique keys on my table [ Currency_code & Rate_Period of VARCHAR Data_Type ]. Manually I checking for duplicates based on key columns in Excel. My requirement is I need sql query to display distinct rows based on the those Yellow highlighted columns. Red Text col's checked manually for duplicate logic in excel. If we notice carefully the value "TRUE" represents duplicate values it should remove and only Unique values (FALSE) values should be returned.
Source Input:
image.png

image.png

Comments
Post Details
Added on Jun 5 2021
3 comments
2,393 views