HAVING 子句

来源:互联网 发布:淘宝网汽车贴膜 编辑:程序博客网 时间:2024/05/29 09:56

mysql> SELECT shohin_bunrui,COUNT(*) FROM Shohin GROUP BY shohin_bunrui HAVING COUNT(*)=2;

SELECT shohin_bunrui ,COUNT(*) FROM Shohin GROUP BY shohin_bunrui;

SELECT shohin_bunrui,COUNT(*) FROM Shohin GROUP BY shohin_bunrui HAVING shohin_bunrui = '办公用品';

WHERE  行对应的条件

HAVING 组对应的条件







0 0
原创粉丝点击