查询大于2个人的省份

 

 SELECT s.shengfeng FROM sf s GROUP BY s.shengfeng HAVING COUNT(NAME)>2

posted @ 2017-08-27 16:16  旁听1  阅读(141)  评论(0)    收藏  举报