Question

写出发贴数最多的十个人名字的SQL 答案

写出发贴数最多的十个人名字的SQL，利用下表：
members(id,username,posts,pass,email)

Answer 1

select top 10 id,username,count(1) as 发贴数 from members group by id,username order by 发贴数 desc

Answer 2

use pubs
SELECT TOP10 job_id,max_lvl FROM dbo.jobs
GROUP BY job_id,max_lvl
ORDER BY max_lvl desc
钱做多的10位。自己改下吧

Answer 3

select top 10 username from members order by posts desc