1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| SELECT `NomAeroDep`,`NomAeroArr`, `HDepChemin`,
`HArrChemin`,`CodeAeroDep`, `CodeAeroArr`
FROM `Chemins_HDepMin_1610` c
WHERE HDepChemin = (SELECT MAX(HDepChemin)
FROM Chemins_HDepMin_1610 c2
WHERE c2.CodeAeroDep = c.CodeAeroDep AND c2.CodeAeroArr = c.CodeAeroArr
)
-- ou encore :
SELECT c.NomAeroDep, c.NomAeroArr, c.HDepChemin,
c.HArrChemin,c.CodeAeroDep, c.CodeAeroArr
FROM Chemins_HDepMin_1610 c
INNER JOIN (
SELECT CodeAeroDep, CodeAeroArr, MAX(HDepChemin) AS DernierDep
FROM Chemins_HDepMin_1610
GROUP BY CodeAeroDep, CodeAeroArr
) c2 ON c.CodeAeroDep = c2.CodeAeroDep AND c.CodeAeroArr = c2.CodeAeroArr AND c.HDepChemin = c2.DernierDep |
Partager