oracle分组查询

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为排序字段