语句如下
---------------------------
seclect A,B,C,D
from user
where
User.D = “1”时
Order by A,B,C
User.D = “2”时
Order by B,C, A
User.D = “3”时
Order by C,B, A
---------------------------
seclect A,B,C,D
from user
where
User.D = “1”时
Order by A,B,C
User.D = “2”时
Order by B,C, A
User.D = “3”时
Order by C,B, A
---------------------------
seclect A,B,C,D
from user
排序要求
User.D = “1”时
Order by A,B,C
User.D = “2”时
Order by B,C, A
User.D = “3”时
Order by C,B, A
select A,B,C,D
from usr
where d = '1'
order by A,B,C)
union all
select * from (
select A,B,C,D
from usr
where d = '2'
order by B,C,A)
union all
select * from (
select A,B,C,D
from usr
where d = '3'
order by d,C,B,A)
;