On Thu, Dec 05, 2002 at 02:00:43PM -0800, Michelle de Beer wrote: > Select * from mytable ORDER by total desc limit 0, 100
See my other most recent reply; you can do it in two queries: CREATE TEMPORARY TABLE Top100 SELECT * ... limit 0,100; SELECT * FROM Top100 ORDER BY ...; The temporary table ceases to exist after you finish your connection, so you don't usually have to worry about cleanup for short-lived programs (like PHP). -- Michael T. Babcock sql CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php