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)a
where rowindex<=5

其中 class是类别字段

rowindex<=5 取出前5