List:General Discussion« Previous MessageNext Message »
From:Dan Buettner Date:March 20 2007 5:35pm
Subject:Re: about limit
View as plain text  
Another solution might be something like:

SELECT * FROM tablename
WHERE id NOT IN (SELECT id FROM tablename WHERE some criteria ORDER BY
something LIMIT 20)
ORDER BY something

Dan

On 3/20/07, Rolando Edwards <redwards@stripped> wrote:
>
> SELECT ... FROM ... LIMIT 20,100000000;
>
> 100 million is a little exaggeration
> but you can other reasonably high numbers.
>
> Remember, LIMITs are zero-based not 1-based.
>
> ----- Original Message -----
> From: "nikos" <nikos@stripped>
> To: mysql@stripped
> Sent: Tuesday, March 20, 2007 12:50:49 PM (GMT-0500) Auto-Detected
> Subject: about limit
>
> Hello list.
>
> Does any body knows how to select not the LIMIT 20 records but the rest
> of them?
>
> MySQL version is 4.1.21-standard and I cant make a VIEW.
>
> Thank you
>
> Nikos
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
about limitnikos20 Mar
  • Re: about limitKevin Hunter20 Mar
  • Re: about limitRolando Edwards20 Mar
    • Re: about limitnikos20 Mar
    • Re: about limitDan Buettner20 Mar
      • Re: about limitPeter Brawley20 Mar