ã?“ã?®ç¯€ã?¯é›†ç´„(ANSI SQL-92ã?§ã?¯é›†å?ˆé–¢æ•°ã€?データベースã?®æ›¸ç±?ã?«ã‚ˆã?£ã?¦ã?¯åˆ—関数ã?¨å‘¼ã?³ã?¾ã?™ã€‚)ã?«ã?¤ã?„ã?¦èª¬æ˜Žã?—ã?¾ã?™ã€‚集約ã?¯ã€?行ã?®é›†å?ˆã?«å¯¾ã?—ã?¦å¼?を評価ã?™ã‚‹æ–¹æ³•ã‚’æ??ä¾›ã?—ã?¾ã?™ã€‚ä»–ã?®çµ„è¾¼ã?¿é–¢æ•°ã?¯å?˜å¼?ã?«å¯¾ã?—ã?¦ä½œç”¨ã?—ã?¾ã?™ã?Œã€?集約ã?¯å€¤ã?®é›†å?ˆã?«å¯¾ã?—ã?¦ä½œç”¨ã?—ã?¦ä¸€ã?¤ã?®ã‚¹ã‚«ãƒ©ãƒ¼å€¤ã?«ã?¾ã?¨ã‚?られã?¾ã?™ã€‚組込ã?¿ã?®é›†ç´„ã?«ã‚ˆã‚Šã€?値ã?®é›†å?ˆã?«å¯¾ã?—ã?¦ã€?å¼?ã?®æœ€å°?値ã€?最大値ã€?å?ˆè¨ˆã€?計数を行ã?„ã€?例ã?ˆã?°è¡Œã‚’æ•°ã?ˆã‚‹ã‚ˆã?†ã?ªäº‹ã?Œã?§ã??ã?¾ã?™ã€‚ã?¾ã?Ÿçµ„è¾¼ã?¿ã?®ã‚‚ã?®ã?¨ã?¯åˆ¥ã?«é›†ç´„を作ã?£ã?¦ã€?例ã?ˆã?°æ¨™æº–å??差を計算ã?™ã‚‹ã‚ˆã?†ã?ªã?“ã?¨ã‚‚ã?§ã??ã?¾ã?™ã€‚
-- not valid
SELECT MIN(flying_time), flight_id
FROM Flights
SELECT c1 FROM t1 GROUP BY c1 HAVING c2 > (SELECT t2.x FROM t2 WHERE t2.y = SUM(t1.c3))
集約ã?Œå¤–ã?®å•?å?ˆã?›ã?«ã?‚ã‚‹å ´å?ˆã€?ã??ã?®ResultSetã?®ã‚«ãƒ¼ã‚½ãƒ«ã?¯æ›´æ–°å?¯èƒ½ã?§ã?¯ã?‚りã?¾ã?›ã‚“。