å¨æ§è¡æ¥è¯¢ç»ææ¶ï¼é»è®¤æ åµä¸æ¥è¯¢ç»ææ åºæåãä½æ们ææ¶éè¦å¯¹æ°æ®æä¸å®è§åè¿è¡æåºãè¿æ¶å¯ä»¥éè¿ORDER BYåå¥æ¥å®ç°è¿ä¸ªåè½ãè¯æ³å¦ä¸ï¼
SELECT <*,column [alias],...> FROM table
[WHERE condition(s)]
[ORDER BY column[ASC|DESC]]ï¼
é»è®¤æ¯ASCæå®çååºæåï¼DESCç¨æ¥æå®éåºæåã
1ãååºæåºï¼
使ç¨ORDER BYåå¥æ¶ï¼é»è®¤æ åµä¸æ°æ®æ¯æååºæåçï¼æ å¯ä»¥ç¨ASCå ³é®åæç¹ååºæåï¼æè ä¸æå®ï¼é»è®¤å°±æ¯ååºï¼æ¾ç¤ºæææ¯ä¸æ ·çï¼å¦ä¸å¾ï¼
2ãéåºæåºï¼
å½éè¦æ¥è¯¢ç»æéåºæåæ¶ï¼å¿ é¡»å¨æåºåæå®DESCå ³é®åãå¦ä¸å¾æ¯æ¥çèåèªæ°´çéåºæåï¼