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]