求一名SQl语句??感谢
表a

a b

3 0
2 1
7 0
8 1

怎么显示

a b
8 1
2 1
7 0
3 0

意思是先按b从大到小排..再按 a从大到小排....在一条语句中,....谢谢!!!

[解决办法]
select * from 表 order by b desc,a desc
[解决办法]
select * from 表 order by b desc,a desc

[解决办法]
declare @t table(a int,b int)
insert @t
select 3, 0 union all
select 2, 1 union all
select 7, 0 union all
select 8, 1

select * from @t order by b desc,a desc

/*结果
a b
-------------
8 1
2 1
7 0
3 0
*/
[解决办法]
select * from 表 order by b desc,a desc