Re: SQL query question - Mailing list pgsql-general

On Sat, Jun 17, 2006 at 16:50:59 -0700,
  Kevin Jenkins <gameprogrammer@rakkar.org> wrote:
>  For example
>
> filename date     revision
> file1    10/05/06 1
> file1    10/05/07 2
> file2    10/05/08 1
>
> I want to do a query that will return the greatest date for each
> unique filename

If the revisions for a filename are guarenteed to be ordered by date, then
another alternative for you would be:

SELECT filename, max(modificationDate), max(revision)
  FROM FileVersionHistory
  GROUP BY filename
;