Dear Eldon,
> record for each device ID without retrieving them all to find the most
> recent name?
SELECT * FROM my_table WHERE ID = LAST_INSERT_ID(ID)
Check: http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solut
On 07 Aug 2001 07:24:59 -0400, Eldon Ziegler wrote:
> I have a table that includes a device ID (indexed) and the name of the
> device with multiple records ordered over time. How can I retrieve the last
> record for each device ID without retrieving them all to find the most
> recent name?
I b
