求简单的sql语句！(升序降序)

[qishihenwunai]

一张成绩表！要按成绩升序并且是班级降序排列！怎么写？

[njlywy]

Select * form 表名 order by 成绩，班级 desc

[abuying]

--使用rank函数，在重值的情况下，不会同名，连续性。
select uid,class from
(select id=Rank()over (order by uid ASC),uid from tb ) a inner join
(select id=rank()over (order by class deSC),class from tb ) b
on a.id=b.id

[kongdie]

太低级了，不作回答。。。

[cxmcxm]

用order by 成绩 desc,班级

[sinpoal]

select * from table_name order by score asc grade desc

[pengpeng409]

select * from score order by banji desc,chengji

[gdk123]

select Classid,score from
(select id=row_number()over (order by Classid ASC),Classid from tb ) a inner join
(select id=row_number()over (order by score deSC),score from tb ) b
on a.id=b.id

[bobo_msdn]

路过！

[david0927cs2006]

select *
from tb
order by 成绩,班级 DESC

[wuguoxian001]

select A.UID,B.CLASS from t as a,t as b order by a.uid desc,b.class asc
试一试会有什么后果 自己想的~~~~~~~

[ningweidong]

select * from tb order by 成绩 ASC,班级 DESC

[王向飞]

...

[zysnba]

都要学好好的学习啊

[qishihenwunai]

[Quote=引用 18 楼 sinpoal 的回复:]
select * from table_name order by score asc grade desc
[/Quote]
可以吗？

[handthing]

楼主思路错了。

[wuguoxian001]

其实我 做过那个例子 是楼主的思路错了

select * from table_name order by score asc grade desc
其实答案就是这个

[abuying]

/**create table t(uid int,class int)
go
insert t values(1,1)
insert t values(2,2)
insert t values(3,3)
insert t values(4,4)
insert t values(5,5)
insert t values(6,6)
**/
select b.uid,a.class from 
 (select class,rank() over(order by class desc) as Rclass from t) as a
inner join
(select uid,rank() over(order by uid asc) as Ruid from t) as b
on a.Rclass=uid

uid         class
----------- -----------
1           6
2           5
3           4
4           3
5           2
6           1

(6 行受影响)

[abuying]

不好意思！
我再改一下
如果是不连接的id

/**create table t(uid int,class int)
go
insert t values(1,1)
insert t values(2,2)
insert t values(3,3)
insert t values(4,4)
insert t values(5,5)
insert t values(6,6)
insert t values(8,7) --多插入一行不连续的id
**/
--select class,rank() over(order by class desc) as Rclass from t
--select uid,rank() over(order by uid asc) as Ruid from t

select b.uid,a.class from 
 (select class,rank() over(order by class desc) as Rclass from t) as a
inner join
(select uid,rank() over(order by uid asc) as Ruid from t) as b
on a.Rclass=Ruid

uid         class
----------- -----------
1           7
2           6
3           5
4           4
5           3
6           2
8           1

(7 行受影响)

[abuying]

不好意思！
我再改一下
如果是不连接的id

/**create table t(uid int,class int)
go
insert t values(1,1)
insert t values(2,2)
insert t values(3,3)
insert t values(4,4)
insert t values(5,5)
insert t values(6,6)
insert t values(8,7) --多插入一行不连续的id
**/
--select class,rank() over(order by class desc) as Rclass from t
--select uid,rank() over(order by uid asc) as Ruid from t

select b.uid,a.class from 
 (select class,rank() over(order by class desc) as Rclass from t) as a
inner join
(select uid,rank() over(order by uid asc) as Ruid from t) as b
on a.Rclass=Ruid

uid         class
----------- -----------
1           7
2           6
3           5
4           4
5           3
6           2
8           1

(7 行受影响)

[fpzgm]

create table t(uid int,class int)
go
insert t values(1,1)
insert t values(2,2)
insert t values(3,3)
insert t values(4,4)
insert t values(5,5)
insert t values(6,6)

select a.uid,b.class from 
  (select uid,row_number()over(order by uid) as row from t) a,
  (select class,row_number()over(order by class desc) as row from t) b
  where a.row=b.row

uid         class
----------- -----------
1           6
2           5
3           4
4           3
5           2
6           1