| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Paul DuBois | Date: | November 28 2000 10:24pm |
| Subject: | Re: Select next 10 | ||
| View as plain text | |||
At 2:07 PM -0800 11/28/00, Steve Lewis wrote: > > >Just with LIMIT >> >SELECT * FROM foo LIMIT 10 > >so I have been wondering... how do I select only the 11th through the 20th >matching records (for example)? It wouldn't be a bad idea to spend some time reading the manual. The section on SELECT answers your questions: http://www.mysql.com/documentation/mysql/commented/manual.php?section=SELECT -- Paul DuBois, paul@stripped
| Thread | ||
|---|---|---|
| • Select top 10 | Rodrigo Pérez | 28 Nov |
| • Re: Select top 10 | personal) | 28 Nov |
| • Re: Select top 10 | Colin Faber | 28 Nov |
| • Re: Select top 10 | Bob Hall | 28 Nov |
| • Re: Select top 10 | Angel Behar Rodriguez | 28 Nov |
| • Copying data between identical tables in different DBFS | Matthew Clark | 28 Nov |
| • RE: Select top 10 | Carsten H. Pedersen | 28 Nov |
| • Re: Select next 10 | Steve Lewis | 28 Nov |
| • Re: Select next 10 | Stephen Johnson | 28 Nov |
| • Re: Select next 10 | Steve Lewis | 29 Nov |
| • Re: Select next 10 | Paul DuBois | 28 Nov |