Forum Stats

  • 3,767,858 Users
  • 2,252,726 Discussions
  • 7,874,366 Comments

Discussions

Query to display distinct rows based on Key columns

User_X9S6M
User_X9S6M Member Posts: 54 Red Ribbon

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:












Comments