1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| SQL> create table t(noda number,dd date);
Table created.
SQL> insert into t values (879300114,to_date('20-JUN-93','DD-MON-RR'));
1 row created.
SQL> insert into t values (879300114,to_date('22-JUN-93','DD-MON-RR'));
1 row created.
SQL> insert into t values (879300114,to_date('23-JUN-93','DD-MON-RR'));
1 row created.
SQL>
SQL> select noda,max(decode(mod(r,2),1,dd)) dd, max(decode(mod(r,2),0,dd)) df from
2 (select noda,dd,row_number() over (partition by noda order by dd) r from t)
3 group by noda,trunc((r+1)/2);
NODA DD DF
---------- ------------------- -------------------
879300114 20.06.1993 00:00:00 22.06.1993 00:00:00
879300114 23.06.1993 00:00:00 |
Partager