Oracle:(select * from (select t.*,ROW_NUMBER() OVER(
PARTITION BY TFMC
ORDER BY 排序时间字段 desc
) ordernum from 实际表 t
where 1= 1) where ordernum=1 )