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
41
42
43
44
45
46
47
48
|
/* Formatted on 25/11/2016 18:16:05 (QP5 v5.163.1008.3004) */
WITH t
AS (SELECT 3205 NUM_POL,
100 CODESITE,
32 CODECATE,
'Steve' CREE_PAR
FROM DUAL
UNION ALL
SELECT 3305,
101,
33,
' Antoine' CREE_PAR
FROM DUAL
UNION ALL
SELECT 3204,
100,
32,
'Gilles' CREE_PAR
FROM DUAL
UNION ALL
SELECT 3306,
101,
33,
'Gilles' CREE_PAR
FROM DUAL
UNION ALL
SELECT 3408,
103,
34,
' Antoine' CREE_PAR
FROM DUAL
UNION ALL
SELECT 3309,
104,
33,
' Antoine' CREE_PAR
FROM DUAL)
SELECT *
FROM T
WHERE cree_par IN ('Steve', ' Antoine')
AND NUM_POL >=
( SELECT MAX (T1.NUM_POL)
FROM T T1
WHERE T.CODESITE = T1.CODESITE
AND T.CODECATE = T1.CODECATE
AND cree_par IN ('Gilles')
GROUP BY T1.CODESITE, T1.CODECATE) |
