日期:2014-05-17 浏览次数:20755 次
select name,type,num from (select name,type, num, rownum()over(partition by name order by num desc) from table1) a left join (select name,max(num) max_num from table1 group by name) b on a.name = b.name order by b.max_num desc,num desc