 | |
#11
 
| |||
| |||
|
Re: Rownum -
01-09-2008
, 03:58 AM
|
On Jan 4, 6:11 am, Andre Rothe <andre.ro... (AT) imise (DOT) uni-leipzig.de 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 |
#12
| |||
| |||
|
|
On Jan 4, 6:11 am, Andre Rothe <andre.ro... (AT) imise (DOT) uni-leipzig.de 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 |
#13
| |||
| |||
|
|
On Jan 4, 6:11 am, Andre Rothe <andre.ro... (AT) imise (DOT) uni-leipzig.de 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 |
#14
| |||
| |||
|
|
May I ask why do you regard ROWNUM a kludge? |
irrelevant. Having
2+2=4
7-4=3
in that order or this one
7-4=3
2+2=4
makes no difference to the truth value. 2+2=4 is true regardless of
where it is stored.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
#15
| |||
| |||
|
|
May I ask why do you regard ROWNUM a kludge? |
irrelevant. Having
2+2=4
7-4=3
in that order or this one
7-4=3
2+2=4
makes no difference to the truth value. 2+2=4 is true regardless of
where it is stored.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
#16
| |||
| |||
|
|
May I ask why do you regard ROWNUM a kludge? |
irrelevant. Having
2+2=4
7-4=3
in that order or this one
7-4=3
2+2=4
makes no difference to the truth value. 2+2=4 is true regardless of
where it is stored.
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.