好吧，我以前问过类似的问题，但我研究过，但没有具体找到这个。
我有一个表，需要按字段 OptionName(NVarChar) 和 IsActive(BIT) 进行排序。
对于 DDL，我需要结果按以下顺序排列：
Option A
Option B
Option C
Options that are Active, by OptionName ASC
Option D
Options that are Inactive, by OptionName ASC
到目前为止我已经
ORDER BY CASE WHEN PortalName = 'Company, Inc' THEN 0 ELSE 1 END,
CASE WHEN PortalName = 'Setup' THEN 1 ELSE 2 END,
CASE WHEN PortalName = 'Daily Routine' THEN 2 ELSE 3 END,
CASE WHEN IsActive = 1 THEN 3 ELSE 4 END,
CASE WHEN PortalName = 'Master Option' THEN 4 ELSE 5 END,
PortalName ASC
但这返回的结果为：
Option A
Option B
Option C
Option D
Options that are Active, by OptionName ASC
Options that are Inactive, by OptionName ASC
任何帮助都会很棒！
try,
ORDER BY CASE WHEN PortalName = 'Company, Inc' THEN 0
WHEN PortalName = 'Setup' THEN 1
WHEN PortalName = 'Daily Routine' THEN 2
WHEN IsActive = 1 THEN 3
WHEN PortalName = 'Master Option' THEN 4
ELSE 5 END,
PortalName ASC
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系:hwhale#tublm.com(使用前将#替换为@)
