SQL那些事儿（五）--oracle字段分组排序

select * from(

select t.*, row_number() over(partition byF_ATTRACTIONID order by F_TIME desc ) rk from T_ATTRACTION_CG t WHERE t.F_TIME<TO_DATE('2015-9-07 00:00:00','yyyy-mm-dd hh24:mi:ss'))select t.*, row_number() over(