----- Original Message -----
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite" <sqlite-users@sqlite.org>
Sent: Monday, June 18, 2007 1:17 PM
Subject: [sqlite] Re: SQL query help
Jeff Godfrey <[EMAIL PROTECTED]>
wrote:
I have a table which contains (among other things), a "name" column
and a "version" column (a software asset table). I need a query
that
will group all like "names" together in a single record, and return
the latest "version" (the largest value) for each group.
select name, max(version)
from asset
group by name;
Igor Tandetnik
Igor,
Perfect - thank you. It's so simple once you see it done... ;^)
Jeff
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
