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