There isn't a BOTTOM, the solution looks something like this:
SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 * FROM table WHERE
clause ORDER BY col) AS temp ORDER BY col DESC) as temp2 ORDER BY col
It's an awful mess, but was the only way I found to select results x to
y in a reliable manner.
Does this work?
select field from (
select row_number() over (order by field) as rn,
field
from table
) x where rn between 6 and 10;
(what the o'reilly "sql cookbook" suggests will work).
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
