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) |
Partager