Re: Retrive a set of tuple

From: Eugenio <eugenio.spadafora_nospam_at_compaq.com>
Date: 2000/07/05
Message-ID: <8juu4r$95u$1@mailint03.im.hou.compaq.com>#1/1

it's the same.
When you use ROWNUM in the Thomas's query you're applying ROWNUM on an inline view (the inner select).

Ciao

--
be happy

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
Simone Celli_Marchi wrote in message <8jutdl$q61$1_at_le.cs.unibo.it>...


>Eugenio <eugenio.spadafora_nospam_at_compaq.com> wrote:

>> You should use the Thomas's query because

>> ROWNUM is a pseudo-column populated during the query itself.

>

>And if I apply it on a view?

>Example:

>

>SELECT * from my_view where ROWNUM>x AND ROWNUM<y ?

>

>> I hope that helps

>

>Yes, thank you!

>

>--

>SysAdm on cantina.students.cs.unibo.it

>Undergraduate student of Computer Science

>http://caristudenti.cs.unibo.it/~celli

>Key fingerprint = D8BD F3D0 00A5 9C96 4A07  DE62 2A4C EDE1 06AA E5BC

>

Received on Wed Jul 05 2000 - 00:00:00 CDT