依据排序字段，筛选两条相同记录中最新的那一条

 

 

 

 

 

 

 

 

如上表排序字段为flowcount，当askid与status相同时，需要筛选出flowcount最大（即最新）的那一条记录

SELECT  auditid, askid, status, flowcount FROM
(
       SELECT ROW_NUMBER() OVER(PARTITION BY askid, status ORDER BY flowcount DESC) LEV,
              auditid, askid, status, flowcount
       FROM TESTYIBAN s
)
WHERE LEV = 1;

转载于:https://www.cnblogs.com/SSatyr/p/3449070.html