1、分组并排序
以col1分组,以col2排序并返回排序编号n
SELECT
*,
ROW_NUMBER () OVER ( PARTITION BY col1 ORDER BY col2 DESC ) AS n
FROM
table_name
2、指定排序
SELECT * FROM table_name
ORDER BY
CASE
WHEN col = value1 THEN 1
WHEN col = value2 THEN 2
WHEN col = value3 THEN 3
WHEN col = value4 THEN 4
ELSE 5
END