Ed Prochak wrote:
> On Jan 4, 6:11 am, 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=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
>
> 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
May I ask why do you regard ROWNUM a kludge?
|
