Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > Rownum
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 3069 of 3210
Post > Topic >>

Rownum

by Andre Rothe <andre.rothe@[EMAIL PROTECTED] > Jan 4, 2008 at 12:11 PM

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
 




 6 Posts in Topic:
Rownum
Andre Rothe <andre.rot  2008-01-04 12:11:11 
Re: Rownum
Lennart <Erik.Lennart.  2008-01-04 05:33:13 
Re: Rownum
Ed Prochak <edprochak@  2008-01-04 10:36:47 
Re: Rownum
Gene Wirchenko <genew@  2008-01-04 13:39:34 
Re: Rownum
Picard <picard@[EMAIL   2008-01-09 09:58:52 
Re: Rownum
Gene Wirchenko <genew@  2008-01-09 13:19:19 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 0:55:24 CDT 2008.