oracle 自增序列及分组查询取某一条（row_number()函数）select *from (select t.*,row_number() over(parti
oracle 自增序列及分组查询取某一条（row_number()函数）
select * from (select t.*, row_number() over(partition by car_num, car_numcolor order by cap_date) as rn from? c_picrecord t) a where a.rn = 3