解决方案 »
- oracle插入的数据和查询出的数据不一致
- Oracle与插件DevExpress XtraTreeList兼容性问题
- ORacle数据库实现异步备份(两台小型机)
- 一个sql语句
- ORA-00604错误:安装STATSPACK!
- 帮看两个sql怎么下
- linux下ORACLE监听出错?
- oracle dba登入失敗!!!!!
- sqlserver中的“select *,(select count(*) from TType where ParentID = T.TypeID) as num from TType T ”在oracle怎么写?
- 问一个关于Oracle9i JDeveloper的问题,请有经验的朋友进来看看,谢谢!(初学者)
- 集思广益 C# oracle数据库求一条SQL语句思路。
- 问一个理论问题。。。
with TB as
(select 1 id, '张三' name, 13 age, '男' sex
from dual
union
select 2 id, '李四' name, 13 age, '男' sex
from dual
union
select 3 id, '王武' name, 13 age, '女' sex from dual)
select a.id,
a.name,
decode(age, lag(age, 1, 0) over(order by id), '', age),
decode(sex, lag(sex, 1, 0) over(order by id), '', sex)
from TB a
DECODE(T1.AGE, T2.AGE, '-', T1.AGE),
DECODE(T1.SEX, T2.SEX, '-', T1.SEX)
FROM (SELECT T.*, ROWNUM R_NUM FROM TEST1 T) T1,
(SELECT T.*, ROWNUM R_NUM FROM TEST1 T) T2
WHERE T1.R_NUM - 1 = T2.R_NUM(+);