1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
create table t (f1 number, f2 number);
SQL> insert into t values (1,2);
1 row created.
SQL> insert into t values (2,1);
1 row created.
SQL> insert into t values (3,4);
1 row created.
SQL> insert into t values (4,3);
1 row created.
SQL> insert into t values (5,6);
1 row created.
SQL> insert into t values (6,5);
1 row created.
SQL> select * from t ;
F1 F2
---------- ----------
1 2
2 1
3 4
4 3
5 6
6 5
6 rows selected.
select f1,f2 from(
select f1,F2, lag(f1) over( order by f1,f2 desc) f3 from t order by f1,f2)
where f2=f3
/
F1 F2
----- -----
2 1
4 3
6 5 |
