oracle查询问题

[a576412747]

数据类型如下：
id name age sex
1 张三 13 男
2 李四 13 男
3 王武 13 女

查的结果如下：
id name age sex
1 张三 13 男
2 李四 ‘’ ‘’
3 王武 ‘’ 女
查出的条数不变，但是相同字段用空格来代替

[居然有人说长得比我帅]

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

[CT_LXL]

SELECT T1.NM,
       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(+);

[龙的传人1988]

2楼正确，经典收藏着