1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
SELECT MIN(date_modified) FROM Requête3 r3
WHERE date_modified >= TO_DATE('22/02/2005 11:09:37', 'DD/MM/YYYY HH24:MI:SS')
AND date_modified <= TO_DATE('06/02/2006 10:15:46', 'DD/MM/YYYY HH24:MI:SS')
AND EXISTS
(SELECT 1
FROM Requête3
WHERE date_modified =
(SELECT MAX(date_modified)
FROM Requête3
WHERE date_modified >= TO_DATE('22/02/2005 11:09:37', 'DD/MM/YYYY HH24:MI:SS')
AND date_modified <= TO_DATE('06/02/2006 10:15:46', 'DD/MM/YYYY HH24:MI:SS'))
AND new_value IN (80, 90))
AND new_value IN (80, 90)
AND NOT EXISTS
(SELECT 1
FROM Requête3
WHERE date_modified > r3.date_modified
AND new_value NOT IN (80, 90)); |
Partager