At 13:52 -0500 7/5/04, Mike Blezien wrote:
Hello,
what is the most effecient way to query the last record in a table,
if querying the primary key(acctid) column ??
What do you mean by last? The row containing the largest acctid value?
You might try ... ORDER BY acctid DESC LIMIT 1.
I've tried
Hi Tia,
I'm not sure, but my old SQL trick was to do a select * top 1 from
subscribers order by acctid desc
Scotty.
-Original Message-
From: Mike Blezien [mailto:[EMAIL PROTECTED]
Sent: July 5, 2004 2:52 PM
To: MySQL List
Subject: Query last record in table
Hello,
what is the most