----- 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]
-----------------------------------------------------------------------------

Reply via email to