|
-
Try This
Select , from table
where
rownum <=10
minus
Select , from table
where
rownum <=0
And keep changing the rownum variable and manage the output of the row,,,
something like this
Select , from table
where
rownum <=:variable1
minus
Select , from table
where
rownum <=:variable2
o to 10
10 to 20
etc..
etc..
Vijay.s
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|