1. °´ÁÐÃûÅÅÐò£¬Ä¬ÈÏÊÇÉýÐòµÄ¡£
µ¥ÁÐÉýÐò£ºselect from order by ;
µ¥ÁнµÐò£ºselect from table_name order by desc;
¶àÁÐÉýÐò£ºselect , from table_name order by , ;
¶àÁнµÐò£ºselect , from order by desc, desc;
¶àÁлìºÏ½µÐò£ºselect column_one, column_two from table_name order by column_one desc, column_two desc;
2. °´ÁеÄλÐòÅÅÐò, ĬÈÏÊÇÉýÐò
select * from order by 1
3. NULLÅÅÐò
¿ÕÖµÔÚÇ°£ºselect from order by NULLS FIRST;
¿ÕÖµÔÚºó£ºselect from order by NULLS LAST;