求一SQL语句（按两个条件查询SQL）
有一表AA ，
自动编号ID 分数num
要按分数从高到低排列，当分数相同时按ID顺序排列，
这样的SQL要怎么写啊，谢谢高手，呵呵！
[解决办法]
select * from AA order by num desc, id
[解决办法]
分类相同时按ID倒序
select * from AA order by num desc, id desc
[解决办法]
用游标试试:
declare @id int
declare rank cursor for
select [id] from AA order by num desc, id desc
open rank
fetch next from rank into @id
while( @@FETCH_STATUS = 0)
begin
select * from AA where [id]=id
fetch next from rank into @id
end
close rank
deallocate rank
