34,588
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([id] int,[status] int,[name] nvarchar(21))
Insert #T
select 1,0,N'a' union all
select 2,1,N'b' union all
select 3,1,N'c' union all
select 4,1,N'd' union all
select 5,0,N'e' union all
select 6,0,N'f'
Go
--测试数据结束
SELECT *
FROM #T
ORDER BY status ,
CASE WHEN status = 0 THEN ASCII(name)
ELSE -ASCII(name)
END