oracle分组取最大的一条
select t1.info_id,t1.info_type,t1.create_city from ( select row_number() over(partition by create_city order by t2.create_date desc) rn, t2.* from T_LABOURUNION_INFO t2 where t2.info_type = '500...
原创
2018-06-28 09:47:52 ·
4014 阅读 ·
0 评论