|
Can anybody tell me how can I replace this
statement
select * from (select SUBQ.*,ROWNO ROW_NUM FROM (SELECT * FROM COUNTRIES) SUBQ WHERE ROWNO <= 10 ORDER BY ROW_NUM DESC) WHERE ROWNO <= 5 ORDER BY ROW_NUM ASC wich works in Oracle,
to have the result in sapdb. It doesn't work,
because "order by" statement can't be used in subquery!
In this exmple, I would like to get 5 records down
starting at position number 10.
Best regards,
Slawek |
