Il suffit d'utiliser MAX, non ?

SELECT Client.IDClient AS IDClient,
Client.civilite AS civilite,
Client.nom AS nom,
Client.prenom AS prenom,
Client.mail AS...