Hi,
Did anyone knows a database system which can execute the following query:
select *
from (select rownum t, a, b, c, d from datatable where c=1 order by a,b,c)
where t=15
In Oracle I get the 15th row of the subquery, but I cannot find another
system which has implemented the rownum functionality like Oracle.
Ideas?
Thanks a lot
Andre


|