General information
Forum:
Microsoft SQL Server
Title:
Sql Syntax to make this group by ?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only