sql - 具有多列的 SELECT 动态排序

Question

当 ORDER BY 基于 CASE 语句时，选择多个 ORDER BY 列的正确 MS SQL 语法是什么？

下面的内容适用于单列，但我需要按多列排序:

SELECT * FROM Products
ORDER BY 
CASE WHEN @SortIndex = 1 THEN Price END ASC,
CASE WHEN @SortIndex = 2 THEN Price DESC, Title ASC END <-- problem line

Answer 1

你可以试试这个

SELECT * FROM Products
ORDER BY 
CASE WHEN @SortIndex = 1 THEN Price END ASC,
CASE WHEN @SortIndex = 2 THEN Price END DESC, 
CASE WHEN @SortIndex = 2 THEN Title END ASC