oracle 查询结果自定义排序
SELECT
*
FROM
table_name
WHERE
id IN (a,
b,
c)
ORDER BY
CASE
id WHEN a THEN 1
WHEN b THEN 2
WHEN c THEN 3
END;
SELECT
*
FROM
table_name
WHERE
id IN (a,
b,
c)
ORDER BY
CASE
id WHEN a THEN 1
WHEN b THEN 2
WHEN c THEN 3
END;