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
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 "
