日期:2014-05-17 浏览次数:21023 次
select * from (select a.name,count(b.id) from user a,friend b where a.id=b.id group by a.name order by count(b.id) desc) where rownum < 4