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