Friday, March 30, 2012

Rownum

I am trying to do a
select count(*) on tablename
where rownum>40000
There are 70000 rows in the table, but my results are 0. How do I get the count above the 40000?
Thanks.row num is alloted to the rows fetched from the query.
if u put the rownum > conditon, no rows will be fetched because it will not satisfy the condition while ROWS are in teh table.

I hope i am clear|||How can I return the rows above 40000? I need to put 70000 rows of data on Excel, but an Excel table holds only 67000 rows.
Thanks.|||Here is a solution,

select *
from table
minus
select *
from table
where rownum < x|||Thank you very much.

No comments:

Post a Comment