oracle中分组查询并且查询每组前几条数据
select * from (
SELECT b,c,row_number() OVER(PARTITION BY b ORDER BY c desc) e FROM test_table) t where e <= 3
b为分组字段, c为排序字段
select * from (
SELECT b,c,row_number() OVER(PARTITION BY b ORDER BY c desc) e FROM test_table) t where e <= 3
b为分组字段, c为排序字段