|Subject:||SQL query dilemma|
|Date:||21 Aug 2006|
Say you have table with that is filled with the amount of dollars for a
project for given dates.
i.e. 3 columns - Project, Amount, Date
A project could have multiple entries in the tabke but this will vary
depending on the Date
How would you query the top 10 projects in regards to most amount of
dollars where each project has to use the latest date in regards to
amount of dollars.
I tried to use Group By but got stumped as I didn't know how to group
Amount using the Max(Date).
So does anyone know how to achieve this?