MINã?¯é›†ç´„関数ã?§ã€?全行ã?«æ¸¡ã‚‹å¼?ã?®æœ€å°?値を求ã‚?ã?¾ã?™ã€‚ (集約 (集å?ˆé–¢æ•°)ã‚’å?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。) MINã?¯çµ„ã?¿è¾¼ã?¿ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?«å¯¾ã?—ã?¦ã?®ã?¿é?©ç”¨å?¯èƒ½ã?§ã?™ã€‚(ã?“れã?«ã?¯CHARã€?VARCHARã€?DATEã€?TIMEç‰ã?Œå?«ã?¾ã‚Œã?¾ã?™ã€‚)
MIN ( [ DISTINCT | ALL ] å¼? )
SELECT COUNT (DISTINCT flying_time), MIN (DISTINCT miles) FROM Flights
ã?“ã?®å¼?ã?«ã?¯è¤‡æ•°ã?®åˆ—ã?¸ã?®å?‚ç…§ã‚„å¼?を書ã??ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ã?—ã?‹ã?—ã€?副å•?å?ˆã?›ã‚„ä»–ã?®é›†ç´„を書ã??ã?“ã?¨ã?¯ã?§ã??ã?¾ã?›ã‚“。 å¼?ã?¯çµ„è¾¼ã?¿ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?¨ã?—ã?¦è©•価ã?•れã?ªã?‘れã?°ã?ªã‚‰ã?šã€?従ã?£ã?¦ãƒ¡ã‚½ãƒƒãƒ‰ã‚’呼ã?¶ã?ªã‚‰çµ„è¾¼ã?¿ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?«è©•価ã?•れã?ªã?‘れã?°ã?ªã‚Šã?¾ã?›ã‚“。(例ã?ˆã?°ã€?java.lang.Integerã‚„intã‚’è¿”ã?™ãƒ¡ã‚½ãƒƒãƒ‰ã?§ã?‚ã‚‹ã?ªã‚‰ã€?INTEGERã?¨è©•価ã?•れã?¾ã?™ã€‚)ã‚‚ã?—å¼?ã?ŒNULLã?¨è©•価ã?•れるã?®ã?§ã?‚れã?°ã€?ã??ã?®å€¤ã?¯é›†ç´„ã?«ã?¦ç„¡è¦–ã?•れã?¾ã?™ã€‚
åž‹ã?«ã‚ˆã‚Šæœ€å°?値を決ã‚?ã‚‹è¦?則ã?¯ç•°ã?ªã‚Šã?¾ã?™ã€‚CHARã€?VARCHARã?§ã?¯ã€?MINã?®è©•価çµ?æžœã?¯å€¤ã?®æœ«å°¾ã?«ã?‚ã‚‹ç©ºç™½æ–‡å—æ•°ã?«å½±éŸ¿ã?•れã?¾ã?™ã€‚ 例ã?ˆã?°'z'ã?¨'z 'ã?Œåˆ—ã?«è¨˜éŒ²ã?•れã?¦ã?„ã?Ÿã?¨ã?—ã?¦ã€?ã?©ã?¡ã‚‰ã?®å€¤ã?Œæœ€å°?値ã?¨ã?—ã?¦è¿”ã?•れるã?‹ã‚’決ã‚?る方法ã?¯ã?‚りã?¾ã?›ã‚“。ã?ªã?œã?ªã‚‰ã?°æ–‡å—列ã?®æ¯”較ã?«ã?¦ç©ºç™½æ–‡å—ã?¯ç„¡è¦–ã?•れるã?‹ã‚‰ã?§ã?™ã€‚
çµ?æžœã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?¯å‡¦ç?†ã?™ã‚‹å¼?ã?®ãƒ‡ãƒ¼ã‚¿åž‹ã?¨å?Œã?˜ã?§ã?™ã€‚(オーãƒ?ーフãƒãƒ¼ã?™ã‚‹ã?“ã?¨ã?¯ã?‚りã?¾ã?›ã‚“。)
-- 有効���り��ん。 SELECT DISTINCT flying_time, MIN(DISTINCT miles) from Flights -- 有効��。 SELECT COUNT(DISTINCT flying_time), MIN(DISTINCT miles) from Flights -- 最も若�日付を探���。 SELECT MIN (flight_date) FROM FlightAvailability;