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>
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