On Sat, Jun 17, 2006 at 16:50:59 -0700,
Kevin Jenkins <gameprogrammer(at)rakkar(dot)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
;