SELECT * FROM Questions
WHERE Identifier = @identifier AND Flag <> 'DELETED'
ORDER BY Status DESC, Number,
(case when flag is null then 1 else 0 end) desc, flag
你可以试试看
SQL查询“ ORDER BY”在3个不同的列上
SELECT * FROM Questions
WHERE Identifier = @identifier AND Flag <> 'DELETED'
ORDER BY Status DESC, Number,
(case when flag is null then 1 else 0 end) desc, flag
你可以试试看