Results 1 to 5 of 5

Thread: Rownum

  1. #1
    Join Date
    Aug 2003
    Posts
    328

    Unanswered: 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.

  2. #2
    Join Date
    Nov 2003
    Location
    Rotterdam, Netherlands
    Posts
    127
    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

  3. #3
    Join Date
    Aug 2003
    Posts
    328
    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.

  4. #4
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Here is a solution,

    select *
    from table
    minus
    select *
    from table
    where rownum < x
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  5. #5
    Join Date
    Aug 2003
    Posts
    328
    Thank you very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •