排序查詢(order by 子句)

admin

select * from yourtable where fields between 105 and 115 order by fields;(由小至大排序)
select * from yourtable where fields between 105 and 115 order by fields desc;(由大至小排序)
範例說明:
查詢資料表,依照fields欄位值介於105-115查詢做排序
使用order by子句來排序,預設由小至大,使用desc則可由大至小作排序
詳細範例說明如下圖說明: