Posted by ree321 on 08/22/06 06:26

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?

[Back to original message]