Ed Prochak <edprochak@[EMAIL PROTECTED]
> wrote:
>On Jan 4, 6:11 am, Andre Rothe <andre.ro...@[EMAIL PROTECTED]
>
>wrote:
>> 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.
I agree with Ed, except for the bit of it being his humble
opinion that it is an abomination. It *IS* an abomination.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
|
