Oracle分组查询时间最大的数据行



例子:分组查询时间最大的数据行。

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