Oracle取归类前N条记录方法汇总

Oracle取分类前N条记录方法汇总

select id,name,class,date from(select id,name,class,date ,row_number() over(partition by class order by date desc)as rowindex from table1)awhere rowindex<=5