!--a11y-->

HAVING ‹å‚Å‚Í�A�ðŒ�‚ðŽg—p‚µ‚Ä‘I‘ð‚³‚ê‚éƒOƒ‹�[ƒv‚Ì�”‚ð�§ŒÀ‚µ‚Ü‚·�B
HAVING ‹å‚Í�A•K‚¸ GROUP BY ‹å‚Æ‘g‚Ý�‡‚킹‚ÄŽg—p‚µ‚Ü‚·�B
�sƒOƒ‹�[ƒv‚ð‘I‘ð‚·‚é‚É‚Í�AˆÈ‰º‚ðŽg—p‚µ‚Ü‚·�B
SELECT <
�s>
<s1> [AS <a1>] <s2> [AS <a2>] ...
<agg> <sm> [AS <am>] <agg> <sn> [AS <an>]
...
...
GROUP BY
<s1> <s2> ....
HAVING
<cond>.
HAVING ‹å‚ÅŽg—p‚Å‚«‚é�ðŒ� <cond> ‚Í�ASELECT ‹å ‚Ì�ðŒ� <cond> ‚Æ“¯‚¶‚Å‚ ‚è�ASELECT ‹å‚©‚ç‚Ì—ñ‚¾‚¯‚ðŽg—p‚Å‚«‚邯‚¢‚¤�§ŒÀ‚ª•t‚«�AFROM ‹å‚̃f�[ƒ^ƒx�[ƒXƒe�[ƒuƒ‹‚©‚ç‚Ì‚·‚ׂĂ̗ñ‚ÍŽg—p‚Å‚«‚Ü‚¹‚ñ�B–³Œø‚È—ñ‚ðŽg—p‚·‚邯�AŽÀ�sŽžƒGƒ‰�[‚ª•\ަ‚³‚ê‚Ü‚·�B
‚½‚¾‚µ�AGROUP BY ‹å‚É•\ަ‚³‚ê‚È‚¢ƒf�[ƒ^ƒx�[ƒXƒe�[ƒuƒ‹‚©‚ç“Ç‚Ý�ž‚܂ꂽ‚·‚ׂĂ̗ñ‚ɑ΂·‚é�W�‡Ž®‚ð“ü—Í‚·‚邱‚Æ‚ª‚Å‚«‚Ü‚·�B‚‚܂è�ASELECT ‹å‚É“o�ꂵ‚È‚¢�W�‡Ž®‚Å‚àŽg—p‚·‚邱‚Æ‚ª‚Å‚«‚邯‚¢‚¤‚±‚Ƃł·�BWHERE ‹å‚Ì�ðŒ�‚Å�W�‡Ž®‚ðŽg—p‚·‚邱‚Ƃ͂ł«‚Ü‚¹‚ñ�B
WHERE ‹å‚Æ“¯—l‚É�AHAVING ‹å‚Ì�ðŒ�‚ð�A�sƒf�[ƒ^Œ^ C ‚ÅŒ…�” 72 ‚Ì“à•”ƒe�[ƒuƒ‹‚Ì“à—e‚Æ‚µ‚ÄŽw’è‚·‚邱‚Æ‚ª‚Å‚«‚Ü‚·�B

DATA WA TYPE SFLIGHT.
SELECT
CONNID
INTO WA-CONNID
FROM SFLIGHT
WHERE CARRID = 'LH'
GROUP BY CONNID
HAVING SUM( SEATSOCC ) > 300.
WRITE: / WA-CARRID, WA-CONNID.
ENDSELECT.
‚±‚Ì—á‚Å‚Í�Aƒf�[ƒ^ƒx�[ƒXƒe�[ƒuƒ‹ SFLIGHT ‚©‚ç�ACARRID ‚Ì’l‚ª �eLH�f ‚Å CONNID ‚Ì’l‚ª“¯ˆê‚Ì�sƒOƒ‹�[ƒv‚ð‘I‘ð‚µ‚Ü‚·�B ŽŸ‚ɃOƒ‹�[ƒv‚Í�AƒOƒ‹�[ƒv‚Ì—ñSEATSOCC ‚Ì“à—e‚Ì�‡Œv‚ª 300 ‚ð’´‚¦‚邯‚¢‚¤�ðŒ�‚É‚æ‚Á‚Ä‚³‚ç‚É�§ŒÀ‚³‚ê‚Ü‚·�B