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

Reply via email to