SQL query dilemma

Giganews Newsgroups
Subject: SQL query dilemma
Posted by:  ree3…@gmail.com
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?

Replies