declare @t table(id int, 职位 varchar(10))
insert @t select 1, '员工'
insert @t select 2, '经理'
insert @t select 3, '员工'
select * from @t order by (case 职位 when'经理' then 0 else 1 end)
insert @t select 1, '员工'
insert @t select 2, '经理'
insert @t select 3, '员工'
select * from @t order by (case 职位 when'经理' then 0 else 1 end)
insert into @a select 1,'员工'
insert into @a select 2,'经理'
insert into @a select 3,'员工'
select * from @a order by case when 职位='经理'then 0 else 1 end
insert into @a select 1,'员工'
insert into @a select 2,'经理'
insert into @a select 3,'员工'
select * from @a order by case when id=2 then 0 else 1 end