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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
