Subject Re: [firebird-support] Help with query?
Author Milan Babuskov
sbussinger wrote:
> Take a simple table with 4 columns (Timestamp, VersionNumber, Client,
> Speed) representing clients downloading new versions of our software
> and what download rates they're getting. I'd like a query that returns
> the rows representing the first time each client downloaded each
> version. If a client does not download a particular version there
> would be no rows for those. A client may download a version several
> times but I want only the first of those downloads (smallest
> timestamp). There will be many versions of software.

select client, versionnumber, min(timestamp)
from your_table
group by client, versionnumber

Milan Babuskov