语句如下
---------------------------
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
解决方案 »
- 请大家进来看看结果为何有差别,用hibernate连oracle10g进行查询的4种写法
- 如何实现序号自动增量
- exp /imp 问题.急呀
- plsql下面 没有connect as选择项
- 一个具有挑战性的SQL语句
- 求教一个查询过程中排序影响效率的问题
- 急,求助,解决马上结贴,100分,为什么我的job_queue_process进程数老是没法修改?
- 如何在PLSQL 中写视图
- 刚刚安装好的ORACLE使用SQL*PLUS怎么进?
- 关于创建临时表的一个问题,很简单的?
- 哪儿可以下载oracle8.1.6 for windows 2000 server
- 请问哪里有oracle学习和帮助文档,最好可以下载看的,参与者有分
---------------------------
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)
;