Hi everybody,

I Have a Note table look like that

UniqueId  ClientId  Note                 Date
1         1         Comments Bla Bla     2003-01-15
2         1         xxx yyyy sfdfd       2003-02-01
3         1         yyrtr bghggggg       2003-01-19
4         2         zzzz zzzz kdfjd      2001-01-15
5         2         zzrrrrrr rrrrr       2003-01-01

I would like to have only one note per Client but the one who have the greatiest Date.

Exemple of the result i want.

UniqueId  ClientId   Note                Date
2         1         xxx yyyy sfdfd       2003-02-01
5         2         zzrrrrrr rrrrr       2003-01-01

I try a lot of thing but noting work fine
Do you have an idea of the Syntaxe i need to do the jod...
Thank's in Advance
Rock