Posted by Oli Filth on 04/11/06 15:21

endlesstide@gmail.com wrote:
> SELECT * FROM table WHERE id BETWEEN 250
> AND 300 ORDER BY value ASC
>
> If I run something like this, it explicitly orders only the 50 records
> separate from the others. You see, I want those to be ordered against
> the entire list -- and grab specified ranges.

If I understand you correctly, you should check out the LIMIT clause in
SELECT statements.

--
Oli

[Back to original message]