sql - How to select distinct records based on condition

Question

I have table of duplicate records like Now I want only one record from duplicate records which has latest created date as How can I do it ?

Answer 1

use row_number():

select EnquiryId, Name, . . .
from (select t.*,
             row_number() over (partition by enquiryID order by CreatedDate desc) as seqnum
      from table t
     ) t
where seqnum = 1;