SQL实现有多条记录ID相同，取时间最近的一条

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是时间栏位