Order by 按照自定义顺序排序 

SELECT
    *
FROM
    table_name
ORDER BY
    decode(
        col_name,
        'value1',
        1,
        value2 ',2,value3',
        3,
        value4 ',4,...valueN',
        N
    )

 

posted @ 2018-05-30 20:13  bug_hua  阅读(4614)  评论(0)  编辑  收藏  举报