|
Slawomir Latka wrote:
> 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. Are we
talking about
select *
from
(select *, rownum row_num from countries where rownum
<= 10) subq
where
row_num >= 6
?
Elke
SAP Labs
Berlin
|
- ROWNO Slawomir Latka
- Zabach, Elke
