Query to display distinct rows based on Key columns

User_X9S6M

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:

EdStevens

This isn't really a question about SQL Developer, but just a general SQL question. A better fit would be https://community.oracle.com/tech/developers/categories/sql_and_pl_sql

cormaco

Do you mean like this:

select distinct currency_code, rate_period from your_table

User_X9S6M

@cormaco Yes! but the Rate_period column some months are missing when I check in excel able to see DUP's