Re: SORTing / LIMITing on max(fieldname) blah-blah

[robert_rowe]

Or you could use a subquery:


SELECT id, image, width, height FROM images
WHERE reference_number=(Select max(id) From images) 
ORDER BY image




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