Re: SELECT to get last entry

2001-08-07 Thread Stefan Hinz
mmerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: "Eldon Ziegler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 1:

Re: SELECT to get last entry

2001-08-07 Thread Tonu Samuel
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

SELECT to get last entry

2001-08-07 Thread Eldon Ziegler
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? Eldon Ziegler ProAtion Systems [EMAIL PROTECTED] http://www.pro