|
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
Navigation:
[Reply to this message]
|