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
|
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as mni
SQL>
SQL> With Data As (
2 Select 1 id, '01/01/2012' dat, 'x1' val from dual union all
3 Select 1 id, '01/01/2012' dat, 'x2' val from dual union all
4 Select 1 id, '02/02/2012' dat, 'x1' val from dual union all
5 Select 1 id, '02/02/2012' dat, 'x4' val from dual union all
6 Select 2 id, '05/02/2013' dat, 'x4' val from dual union all
7 Select 2 id, '06/03/2013' dat, 'x6' val from dual
8 )
9 Select id, dat, val
10 From Data
11 Where (id, dat) in (Select id, Max(Dat)
12 From Data
13 Group By id
14 )
15 Order By id, Dat, val
16 /
ID DAT VAL
---------- ---------- ---
1 02/02/2012 x1
1 02/02/2012 x4
2 06/03/2013 x6
SQL> |
Partager