select * from (select t.*, row_number() OVER(PARTITION BY t.RTID ORDER BY t.createdate desc ) as row_flg from t_sp_processfile t) temp where temp.row_flg = ‘1‘
使用SQL 查询 第一条数据
原文：http://www.cnblogs.com/yunnuo/p/5235991.html
