Oracle取分类前N条记录方法汇总select id,name,class,date from(select id,name,class,date ,row_number()
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