-- #1 >SELECT * FROM mytable mt1 > WHERE NOT EXISTS ( > SELECT * FROM mytable mt2 > WHERE mt2.ClientId = mt1.ClientId And mt2.date > mt1.date) >-- #2 >SELECT * FROM mytable mt1 > WHERE date IN ( > SELECT MAX(date) FROM mytable mt2 > WHERE mt2.ClientId = mt1.ClientId) >>>Hi everybody,
> >>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 >>