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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,360 views