求个查询

Question

本帖最后由 t240034137 于 2011-01-28 12:08:10 编辑

Answer 1

select authorid from asdad 
group by authorid 
having(count(*))>2

Answer 2

select authorid
from 发帖表
group by authorid
having count(*)>1

Answer 3

--发帖数大于2
select authorid
from 发帖表
group by authorid
having count(*)>1

Answer 4

--发帖数大于2
select authorid
from 发帖表
group by authorid
having count(*)>1直接copy！

Answer 5

select authorid
from 发帖表
group by authorid
having count(pid)>2

Answer 6

select authorid, count(*) as cnt
from tbl
group by authorid
having cnt > 2