Question

oracle排序 一个表不同类型数据找出前10名

Answer 1

select * from (select row_number()over(parititon by a order by a) r,a,b from a order by b)

where