if object_id('tb') is not null drop table tb go create table tb( num nvarchar(50)) insert into tb
select '张三' union all select '李四' union all select '王五' union all select '赵六'select * from tb order by (case when num='张三' then 0 else 1 end)
--sinpoal if object_id('tb') is not null drop table tb go create table tb( name char(6)) insert tb select '张三' union all select '李四' union all select '王五' union all select '赵六' --------statement------- select * from tb order by (case when name='张三' then 0 else 1 end)
select * from tb order by (case when name='张三' then 0 else 1 end)
select name from table_1 order by case when name='張三' then 0 else 1 end
order by chareindex(name,'张三 ,李四,王五 ,赵六')
order by case when name='張三' then 0 else 1 end
ORDER BY
CASE WHEN name='张三' THEN 0 ELSE 1 END
,NAME
ORDER BY
CASE WHEN name='张三' THEN 'A' ELSE name END
order by charindex(Name,'张三')
drop table tb
go
create table tb( num nvarchar(50))
insert into tb
select '张三' union all
select '李四' union all
select '王五' union all
select '赵六'select * from tb order by (case when num='张三' then 0 else 1 end)
--sinpoal
if object_id('tb') is not null
drop table tb
go create table tb( name char(6))
insert tb select '张三' union all
select '李四' union all
select '王五' union all
select '赵六' --------statement-------
select * from tb order by (case when name='张三' then 0 else 1 end)
order by case when name='張三' then 0 else 1 end