Re: i am facing a problem with segmentation.

Hi

You can do something like this :

select c1, c2
from (select c1, c2, rownum the_rownum

      from my_table
      order by c1)

hth
Chris

sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0201150125.21c7bc8c_at_posting.google.com>...
> Hi all,
> i am facing a problem, here i am explaining it first.
> suppose i have one customer table where i have near about
> one million data, now i want that i will run different sql
> statements to retrieve the data. in my first select statement
> i will retrieve 1 to 100000 data and in my second select statement
> i will retrieve 1000001 to 300000... so on.
> as i don't know the primary key field of that table or i don't have any
> id field in that case what will be the select statement for that??
>
> thanks
> hoque
Received on Tue Jan 15 2002 - 22:13:24 CET