按条件分组

SELECT 
    * 
FROM 
    USER_FINIST
ORDER BY
    CASE FINIST_CD=17 THEN 0
    CASE FINIST_CD=5 THEN 1
    CASE FINIST_CD=3 THEN 2
    CASE FINIST_CD=12 THEN 3
    END ASC/DESC