try:
select * from a where a2<2002 and a3>2002
union
selec * from a where a2 in (select a2-1 from a where a2<2002 and a3>2002);
select * from a where a2<2002 and a3>2002
union
selec * from a where a2 in (select a2-1 from a where a2<2002 and a3>2002);
解决方案 »
- 提示 未选定行是什么意思?
- 11g rac中 root.sh的执行报错
- 只要你做了,就有分了,谢谢大家帮忙了
- 怎么从oracle里倒出表结构啊?
- 表空间不足!!!!!!!!
- 请问有什么办法能够从有坏块的 .ora 文件里导出数据!
- 错误类型:Provider (0x80004005) /hh/index.asp, 第 147 行200分
- 关于备份所用磁盘的问题
- 在其他的机子上unixware环境下能够安装oracle,但在我的笔记本按同样方法去无法安装,每次到64%时就抱错,那位大虾帮我解决一下吧
- toad 或者golden提示错误如下:估计blob,clob等大字段的显示问题
- 求条查询语句:select * from a where 姓名 like '%x%' 如果x是变量如何写?
- 高分请救一个SQL问题?
UNION
SELECT * FROM T WHERE A2 IN
(SELECT A2 FROM T WHERE A2 < YEAR AND YEAR < A3)
UNION
SELECT * FROM T WHERE A2 IN
(SELECT A2 -1 FROM T WHERE A2 < YEAR AND YEAR < A3)
select distinct a.* from (
select * from a where a2<YEAR and a3>YEAR
union
selec * from a where a2 in (select a2-1 from a where a2<YEAR and a3>YEAR)) a