ORDER BY 節

ORDER BY節ã?¯SELECTæ–‡ã?®çœ?ç•¥å?¯èƒ½ã?ªè¦?ç´ ã?§ã?™ã€‚ ORDER BY節ã?«ã?¦ResultSetã?«ã?‚る行ã?®é †ç•ªã‚’指定ã?§ã??ã?¾ã?™ã€‚

Syntax

ORDER BY { 列å?? | ColumnPosition | Expression }
    [ ASC | DESC ]
    [ , 列å?? | 列ä½?ç½® | å¼? 
        [ ASC | DESC ] ] * 
列å??
å•?ã?„å?ˆã‚?ã?›ã?®SELECT æ–‡ã?®é?¸æŠžé …ç›®ã?«ã?¦ã€?å?¯è¦–ã?§ã?‚ã‚‹å??å‰?ã‚’å?‚ç…§ã?—ã?¾ã?™ã€‚ ORDER BYã?§æŒ‡å®šã?™ã‚‹åˆ—å??ã?¯SELECTã?•れる項目ã?«ã?ªã??ã?¨ã‚‚æ§‹ã?„ã?¾ã?›ã‚“。
列�置
SELECT æ–‡ã?®é?¸æŠžé …ç›®ã?®ã€?列ã?®ç•ªå?·ã‚’指定ã?™ã‚‹æ•´æ•°ã?§ã?™ã€‚ 列ä½?ç½®ã?¯ã€?0より大ã??ã??ã?‹ã?¤çµ?果表ã?®åˆ—数以下ã?§ã?ªã?‘れã?°ã?ªã‚Šã?¾ã?›ã‚“。言ã?„æ?›ã?ˆã‚Œã?°ã€?列ã?§ä¸¦ã?³å¤‰ã?ˆã‚‹ã?Ÿã‚?ã?«ã€?ã??ã?®åˆ—ã?ŒSELECTã?•れる項目ã?«ã?‚ã‚‹å¿…è¦?ã?Œã?‚りã?¾ã?™ã€‚
å¼?
並ã?³å¤‰ã?ˆã‚’行ã?†ã‚­ãƒ¼ã?®å¼?ã?§ã€?数値や文字列ã€?日付ã?ªã?©ã?®å¼?ã?¨ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ å¼?ã?¯ã‚¹ã‚«ãƒ©ãƒ¼å‰¯å•?ã?„å?ˆã‚?ã?›ã‚„CASEå¼?ã?ªã?©ã?®ã€?行ã?®å€¤ã?«ã?Šã?‘ã‚‹å¼?ã?¨ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚
ASC
�果を昇順�返���を指定���。方��指定�れ��場��ASC�既定��。
DESC
�果を�順�返���を指定���。

但ã?—書ã??

相関å??を使ã?†ä¾‹

相関å??ã?Œé?¸æŠžé …ç›®ã?«ã?¦æŒ‡å®šã?•れã?¦ã?„れã?°ã€?çµ?果セットを相関å??ã?§ä¸¦ã?³å¤‰ã?ˆã?§ã??ã?¾ã?™ã€‚ ã?Ÿã?¨ã?ˆã?°CITIESデータベースã?‹ã‚‰ã€?COUNTRY列ã?«NATIONã?¨ã?„ã?†ç›¸é–¢å??を与ã?ˆã?¦ã€?CITY_NAME列ã?¨COUNTRY列ã?«æ ¼ç´?ã?•れã?¦ã?„ã‚‹ã?™ã?¹ã?¦ã?®æƒ…報を返ã?™å ´å?ˆã€?次ã?®ã‚ˆã?†ã?ªSELECT文を書ã??ã?¾ã?™ã€‚

SELECT CITY_NAME, COUNTRY AS NATION 
    FROM CITIES 
    ORDER BY NATION

数�を使�例

çµ?果セットを数å¼?ã?§ä¸¦ã?³å¤‰ã?ˆã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚例を挙ã?’ã?¾ã?™ã€‚
SELECT name, salary, bonus FROM employee 
   ORDER BY salary+bonus
��例���salary�bonus列�DECIMALデータ型��。

関数を使�例

çµ?果セットを関数ã?®å‘¼ã?³å‡ºã?—çµ?果を元ã?«ä¸¦ã?³å¤‰ã?ˆã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚例を挙ã?’ã?¾ã?™ã€‚
SELECT i, len FROM measures 
   ORDER BY sin(i)