Re: Query in Oracle
From: Mark Malakanov <markmal_at_home.com>
Date: Sat, 21 Apr 2001 19:08:39 GMT
Message-ID: <XUkE6.19909$_P.4930071_at_news3.rdc1.on.home.com>
Date: Sat, 21 Apr 2001 19:08:39 GMT
Message-ID: <XUkE6.19909$_P.4930071_at_news3.rdc1.on.home.com>
Actually, there is no a conception of "row position" in theory of relation
databases.
But, of cource, in real databse every row has physical identification of
position.
In Oracle you can use ROWNUM.
select * from
(select rownum rnum,t.* from MyTable t)
where rnum in (200,400,500);
-- ----------------------------------------------------- Thanks, Mark "Daniel Guignard" <danielg_at_speedware.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:3mYD6.3135$vT5.461457_at_weber.videotron.net...Received on Sat Apr 21 2001 - 21:08:39 CEST
> Hi,
> I want to select some row in a table. I have about 100 000 rows and I want
> the row 100, 200, 300,400 and 500 but I don't have any column who identify
> each row with a number.My primary key is alpha-numeric so I don't have any
> number to count the row I wanted.
>
>
>
> Thank
>
> Daniel Guignard
>
> danielg_at_speedware.com
>
>
>