Re: Can I ask for a ROW

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Fri, 05 Jul 2002 08:28:27 GMT
Message-ID: <LMcV8.6$XL5.101@se2-fa199-9.gva.ch.colt.net>

"Oscar" <oscar_ll_at_jofre.com> schrieb im Newsbeitrag news:ag3fn1$jog$1_at_nsnmrro2-gest.nuria.telefonica-data.net...
> Can I make any select for ask for a row pos I mean if I can do any select
> direct for get the 5th row ? Without any col tha has rownumber ?

It was already posted yesterday:

SELECT col1, col2, r2
FROM (SELECT col1, col2, rownum r2

              FROM table1 WHERE rownum < 6
              ORDER BY col1) r

WHERE r2 > 4

Hth,

Knut Received on Fri Jul 05 2002 - 03:28:27 CDT