如何根据条件选择不同的记录 [英] How to select distinct records based on condition

问题描述

我有重复的记录表，如
现在我只想要一个记录来自具有最新创建日期的重复记录为我该怎么做

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 ?

推荐答案

使用ROW_NUMBER函数标记CreatedDate排序的重复记录，如下所示：

Use ROW_NUMBER function to tag the duplicate records ordered by CreatedDate, like this:

;with CTE AS (
    select *, row_NUMBER() over(
                 partition by EnquiryID -- add columns on which you want to identify duplicates
                 ORDER BY CreatedDate DESC) as rn
    FROM TABLE 
)
select * from CTE
where rn = 1

这篇关于如何根据条件选择不同的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！