declare @tab table(id int,name1 varchar(20))insert into tab(id,name1) values(0,'aa') insert into tab(id,name1) values(1,'bb') insert into tab(id,name1) values(8,'cc') insert into tab(id,name1) values(9,'dd') insert into tab(id,name1) values(4,'ee') insert into tab(id,name1) values(7,'ff')select * from @tab order by case when id=0 then 1 else 0 end
求选取所有数据并把指定ID的记录排序放在其它记录前面的SQL语句怎么写???
insert into tab(id,name1) values(1,'bb')
insert into tab(id,name1) values(8,'cc')
insert into tab(id,name1) values(9,'dd')
insert into tab(id,name1) values(4,'ee')
insert into tab(id,name1) values(7,'ff')select * from @tab order by case when id=0 then 1 else 0 end