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
http://swoes.blogspot.com/
http://www.flamerobin.org