一个排序的简单问题?多条件排序

[gaopei1122]

表1

a b

1 340
0 320
0 210
1 329
1 403
0 322

想先把a=1的按升序排列,然后a<>1的再按升序排列,该怎么写查询语句

[青锋-SS]

select a,b from 表1 order by a desc,b asc

[青锋-SS]

select a,b from 表1 order by case a when 1 then 0 else 1 end,b asc

[kenny_appleso]

select a,b from 表1 order by case a when 1 then 0 else 1 end,b asc

[jyxhz]

select * from 表1 where a=1 order by b
union all
select * from 表1 where a<>1 order by b

[---涛声依旧---]

三、四樓都可以

[ALLEN625314]

create table #a(
a int,
b int)
go
insert into #a
select 1, 340
union all
select 0, 320
union all
select 0, 210
union all
select 1, 329
union all
select 1, 403
union all
select 0 , 322
go
select * from #a order by a desc,b asc

--drop table #a