SELECT *
FROM(
SELECT fs.*,
ROW_NUMBER() OVER(PARTITION BY fs.new_formname
ORDER BY fs.new_approvedate DESC) fsp
FROM new_flowapproval_steps AS fs
) AS purchase_order_fps
WHERE fsp = 1;
如上,其中new_formname为可能有多条重复的id栏位,new_approvedate是时间栏位