Hello!
I ask for question about sql . I have a sql command like that :
SELECT P.ID_PERMIS,
P.PERMIS,
H.ID_HISTORIQUE,
H.DATEHISTORIQUE,
FROM EXPL_PERMIS P, EXPL_HISTORIQUEPERMIS H
WHERE P.ID_PERMIS=H.PERMIS_ID_PERMIS
ORDER BY ID_PERMIS, ID_HISTORIQUE;
and it return the following :
And I want to obtain the last ID_HISTORIQUE or DATEHISTORIQUE for every ID_PERMIS like that :
