ms sql 双字段排序

Question

select Id,state from dbo.UserSurveyInfo order by [state],[id] desc  查询语句
结果
ID      state
3 0
2 0
1 0
4 1怎么样才能让 状态 倒序排列？

Answer 1

select Id,state from dbo.UserSurveyInfo order by [state] desc,[id] desc

Answer 2

select Id,state 
from dbo.UserSurveyInfo 
order by [state] desc,[id] desc

Answer 3

SELECT ID, STATE
FROM UserSurveyInfo 
ORDER BY STATE DESC