Assuming that the lastest ID is the same as the current name - maybe something like :
select * from sometab t1 where id=( select max(id) from sometab t2 where t1.code=t2.code ) On Thursday 13 July 2006 10:16, Helen M Hudson wrote: > If I have a table > primary key id | code | name > 1 | ABC | company 1 name > 2 | ABC | company 1 name > 3 | ABC | new company 1 name > 4 | ABC | new company 1 name > 5 | DEF | company 2 name > 6 | DEF | company 2 name > 7 | DEF | new company 2 name > 8 | DEF | new company 2 name > > (the company is changing name every now and then and i need to extract > their "latest" name) > > how can i get back > 4 | ABC | new company 1 name > 8 | DEF | new company 2 name -- Mike Aubury -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]