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-01I would like to have only one note per Client but the one who have the greatiest Date.
UniqueId ClientId Note Date 2 1 xxx yyyy sfdfd 2003-02-01 5 2 zzrrrrrr rrrrr 2003-01-01I try a lot of thing but noting work fine