日期:2014-05-18 浏览次数:20477 次
select * from [user] a, [friend] b where a.id=b.u_id and a.id in( select top 3 u_id, count(*) ct from friend group by u_id order by ct desc )