[exdter]

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.

[shelva]

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

[exdter]

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.

[r123456]

Here is a solution,

select *
from table
minus
select *
from table
where rownum < x

[exdter]

Thank you very much.