[SQL]把自己要的資料放在第一筆

SELECT * FROM FBEU.COUNTRY
ORDER BY (CASE WHEN CODE = 'TW' THEN 0 ELSE 1 END) , CODE

SQL好妙，還可以這樣用!

http://www.dotblogs.com.tw/nemochen/archive/2010/07/25/16789.aspx




另外ORDER BY 裡面可以選擇某個欄位要ASC 或 DESC


   SELECT
        DISTINCT
           MENUID,          INS_TYPE,    
           DOMESTIC,      PL4_T1_TSI,     PL4_T2_TSI,
           PL4_RANGE,     PL4_TSI,          COUNT            
    FROM TT_JUC7924_9WF
    WHERE INS_TYPE IN ('T041', 'T042', 'T045')
    ORDER BY MENUID, INS_TYPE, DOMESTIC, PL4_T1_TSI, PL4_T2_TSI DESC, PL4_TSI;


http://stackoverflow.com/questions/8138413/order-by-sql-data-using-condtions-case-based-on-derived-columns