ORDER BY節ã?¯SELECTæ–‡ã?®çœ?ç•¥å?¯èƒ½ã?ªè¦?ç´ ã?§ã?™ã€‚ ORDER BY節ã?«ã?¦ResultSetã?«ã?‚る行ã?®é †ç•ªã‚’指定ã?§ã??ã?¾ã?™ã€‚
ORDER BY { 列å?? | ColumnPosition | Expression } [ ASC | DESC ] [ , 列å?? | 列ä½?ç½® | å¼? [ 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)