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 - 2000-10-18 : 09:43:40
|
Staci writes "I have a query that retrieves the most recent entry for each Client. The query retrieves 7 fields, performs the max on the date entered, and should only display the most recently entered rows for each Client value. But instead, it retrieves all of the rows and just groups them together. Here is the query:
SELECT MAX(DateReported), Client, Project, Status, Budget, TeamStatus, Schedule
FROM ClientProjectData
GROUP BY Client, Project, Status, Budget, TeamStatus, Schedule;
In the database, the key is on Client + Project.
Please help!
Staci" |
|
|
|
|
|
Getting the MAX value