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

其中 class是类别字段

rowindex<=5 取出前5