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
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
