ROWNO

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