Hello,

what is the most effecient way to query the last record in a table, if querying the primary key(acctid) column ??

I've tried "select *,max(acctid) as lastid from subscribers where acctid = 'lastid' group by acctid"
but this returns nothing ??


TIA :)

--
Mike<mickalo>Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://thunder-rain.com
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to