22,210
社区成员
发帖
与我相关
我的任务
分享
//先按模具号分组,再按时间倒序,然后取时间第一个时间的数据
SELECT * FROM
(select ROW_NUMBER() over (patition by 模具号 order by 结束时间 desc) as No,*
FROM 表) A
WHERE A.No=1
select * from (
select row_number() (partition by 模具号 order by 结束时间 desc,seqn desc) as rid,* from t
) as t1 where t1.rid=1
SELECT *
FROM ( SELECT * ,
ROW_NUMBER() OVER ( PARTITION BY 模具号 ORDER BY 结束时间 DESC, seqn DESC ) AS rn
FROM 表
) t
WHERE rn = 1