Select A.* FROM Table A INNER JOIN (Select Col1, Max(Date) as Date from Table group by Col1) B --Sélection des éléments ON A.Col1 B.Col1 and A.Date B.Date
select * from NomDeTaTable where NomDeTonChampDate = (select max(NomDeTonChampDate) from NomDeTaTable)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionselect * from NomDeTaTable where NomDeTonChampDate = (select max(NomDeTonChampDate) from NomDeTaTable) or NomDeTonChampDate = (select max(NomDeTonChampDate) from NomDeTaTable where NomDeTonChampDate <> (select max(NomDeTonChampDate) from NomDeTaTable) )
SELECT `code`, MAX(`date`) FROM `table` GROUP BY `code`;