分组
select row_number() over(partition by 重复字段字段 order by 字段 ) rn,需要的字段(表.*),表名)
可以用通用表查询表达式和Row_Numner()函数来选出重复的那行数据。
SELECT t2.orderno,t2.serviceCode,t2.ctime,t2.memo
FROM
(
SELECT ROW_NUMBER() OVER
(
PARTITION BY t1.orderno,t1.servicecode ORDER BY t1.ctime DESC
)
rn,
t1.*
FROM ORD.t_ordernoderecord t1
)
t2
WHERE t2.rn = 1 ;