多列 SELECT 动态排序 [英] Dynamic Order by SELECT with multiple columns

问题描述

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

What is the correct MS SQL syntax to select multiple ORDER BY columns when the ORDER BY is based on a CASE statement?

以下适用于单列，但我需要按多列排序:

The below works fine with single columns, but I need to sort by multiple columns:

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

推荐答案

你可以试试这个

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 

这篇关于多列 SELECT 动态排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！