Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-25 : 22:49:06
|
David writes "I have a query to gives me a result of the following:
A Date Category
-- -- --
A1 1/1 C1
A1 1/3 C1
B1 1/3 B1
Is it possible to construct a query that will give me just:
A Date Category
-- -- --
A1 1/3 C1
B1 1/3 B1
******
The result are rows with the lastest "Date" for each
distinct "Category"
Thanks in advance." |
|
|
|
|
|
Distinct rows per group