表web_order 列 name ,businesscode,
周桥 18929609222 3754031157710000
妙药 18929609233 3754031157712344
灵丹 18929609189 3754031157710000
周桥 13329609189 3754031157713333
查出一个表中account 出现次数大于2的所有记录
select ,,
from web_order a,
(select ,count() as count
from web_order b
group by
having count()>300
) c
where =
不重复显示
name,bsinesscode,account 并加一列count(account)
select min() ,min(),, count()
from web_order a where 1=1
group by
having count( )>=100