SELECT * FROM table1
ORDER BY
CASE ItemName
WHEN ‘名称1’
THEN
1
WHEN ‘名称2’
THEN
2
WHEN ‘名称3’
THEN
3
ELSE
4
END;
sqlserver自定义规则排序
最新推荐文章于 2024-03-25 10:50:12 发布
SELECT * FROM table1
ORDER BY
CASE ItemName
WHEN ‘名称1’
THEN
1
WHEN ‘名称2’
THEN
2
WHEN ‘名称3’
THEN
3
ELSE
4
END;