having count(XX) mysql informix区别

mysql :

select * from TERMINALPARA having count(mid)>1

 

 

informix

select merch_no  from merchinfo  group by merch_no having count(merch_no)>1

 

select 后必须带列名,不可*,,having count(),,必需在group by 后面.