Re: Query in Oracle

From: André Gamache <andre.gamache_at_sympatico.ca>
Date: Fri, 20 Apr 2001 20:55:08 GMT
Message-ID: <3AE0A348.80B818A8_at_sympatico.ca>


Daniel,

Try using the MOD function :

select *
from R
where num = mod(num, 100) = 0 ;

André

Daniel Guignard wrote:

> 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
  Received on Fri Apr 20 2001 - 22:55:08 CEST

Original text of this message