Hello,
I think I've been starring at this too long :-p

what I would like to do is, I would like to return all of the rows with the highest version number for the group_id.

Quick Table
app_id, name, group_id, app_ver
1000, Foo, com.foo, 1.0
1001, Foo, com.foo, 1.1
1020, Foo, com.foo, 1.4
1005, Bar, com.bar, 1.1
1006, Bar, com.bar, 1.2

Expected Results
1020, Foo, com.foo, 1.4
1006, Bar, com.bar, 1.2

Thanks,
tom

Something like this.

select q.app_id, q.name, q.group_id, q.app_ver
from quick q
join (select group_id, max(app_ver) as max_app_ver
from quick
group by group_id) a on a.group_id = q.group_id
and a.max_app_ver = q.app_ver

Or:

Dave

dave, i've seen multiple times (no links, though, sorry) where someone has done a benchmark of the "join to max derived table" (rayqsl's version) versus the "where max correlated subquery" (your version) and the derived table always outperforms

Thanks, the join makes sense this help a bunch.

thanks again,
tom