HAVING句で特定の条件に合致したレコードを引き出す方法
mysql> SELECT shcd,SUM(suryo) FROM t_hanbai GROUP BY shcd HAVING SUM(suryo)>=10; +--------+------------+ | shcd | SUM(suryo) | +--------+------------+ | 100001 | 10 | +--------+------------+ 1 row in set (0.01 sec)
mysql> SELECT shcd,SUM(suryo) FROM t_hanbai GROUP BY shcd HAVING SUM(suryo)>=10; +--------+------------+ | shcd | SUM(suryo) | +--------+------------+ | 100001 | 10 | +--------+------------+ 1 row in set (0.01 sec)