On Jan 4, 6:11=A0am, Andre Rothe <andre.ro...@[EMAIL PROTECTED]
>
wrote:
> 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=3D1 order by
a,b,=
c)
> where t=3D15
>
> 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
ROWNUM is assigned BEFORE the ORDER BY. it is a kludge and IMHO an
abomination.
you are better off using the ranking functions as Lennart mentioned.
Ed
|
