order by (case dengji when 4 then 'A' when 3 then 'B' when 2 then 'C' when 1 then 'D' end),fenshu desc
select dengji , fenshu from 表名 order by (case when (dengji = 4 or dengji = 3) then 1 when (dengji = 2 or dengji = 1) then 2), fenshu desc
order by case when dengji in(3,4) then 1 when dengji in(1,2) then 2 end,fenshu desc
----------------------下面的例子和實現語句--------- Create Table test( Dengji int, fenshu int )insert into test select 4,80 union all select 3,90 union all select 2,100 union all select 1,70select * from test ---------------------------- select *,a=(case when dengji in (4,3) then 0 else 1 end) from test order by a,fenshu desc ----------------結果-------------------------- DengJi fenshu 3 90 4 80 2 100 1 70
--或者 select * from 表 order by dengji/3 desc,fenshu desc
回复人: didoleo(冷月无声) ( ) 信誉:100 2005-01-15 16:21:00 得分: 0 4、3是同一级别的,他们需要按分数排列 没看到 4,3是同一级别,我的错了. ----------------------------------------------------------- 多谢了,我从你那得到灵感。问题已经解决。谢谢! order by (case dengji when 4 then 'A' when 3 then 'A' when 2 then 'B' when 1 then 'B' end),fenshu desc
回复人: zjcxc(邹建) ( ) 信誉:487 2005-01-15 16:25:00 得分: 0 --或者 select * from 表 order by dengji/3 desc,fenshu desc order by case when dengji in(3,4) then 1 when dengji in(1,2) then 2 end,fenshu desc -------------------------------------- 这个好像也可以谢谢!
when 4 then 'A'
when 3 then 'B'
when 2 then 'C'
when 1 then 'D' end),fenshu desc
dengji ,
fenshu
from
表名
order by
(case when (dengji = 4 or dengji = 3) then 1
when (dengji = 2 or dengji = 1) then 2),
fenshu desc
when dengji in(3,4) then 1
when dengji in(1,2) then 2
end,fenshu desc
Create Table test(
Dengji int,
fenshu int )insert into test
select 4,80 union all
select 3,90 union all
select 2,100 union all
select 1,70select * from test
----------------------------
select *,a=(case when dengji in (4,3) then 0 else 1 end) from test order by a,fenshu desc
----------------結果--------------------------
DengJi fenshu
3 90
4 80
2 100
1 70
select * from 表
order by dengji/3 desc,fenshu desc
4、3是同一级别的,他们需要按分数排列
没看到 4,3是同一级别,我的错了.
-----------------------------------------------------------
多谢了,我从你那得到灵感。问题已经解决。谢谢!
order by (case dengji
when 4 then 'A'
when 3 then 'A'
when 2 then 'B'
when 1 then 'B' end),fenshu desc
--或者
select * from 表
order by dengji/3 desc,fenshu desc
order by case
when dengji in(3,4) then 1
when dengji in(1,2) then 2
end,fenshu desc
--------------------------------------
这个好像也可以谢谢!