使用SQL 查询 第一条数据

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 查询 第一条数据

标签：