----- Original Message -----
From: "P Kishor" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, June 18, 2007 2:55 PM
Subject: Re: [sqlite] SQL query help
On 6/18/07, 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. What I
have
Jeff, how about something like
SELECT name, MAX(version) AS latest
FROM asset
GROUP BY name
Thanks Puneet - that's just what I needed.
Side note - the timing on the list seems to be whacky right now (at
least for me), so some of my responses seem to be coming out of order.
Sorry if that causes some confusion...
Thanks again.
Jeff
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
