例子:分组查询时间最大的数据行。
select t2.* from
(select t1.*,row_number() over (partition by t1.sheet_id order by t1.check_time desc nulls last) rn from dispatch_result t1) t2
where rn=1
例子:分组查询时间最大的数据行。
select t2.* from
(select t1.*,row_number() over (partition by t1.sheet_id order by t1.check_time desc nulls last) rn from dispatch_result t1) t2
where rn=1