DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: < > Question

  1. 04-22-2003, 02:48 PM #1
    Rwbrown
    Rwbrown is offline Junior Member
    Join Date
    Apr 2003
    Posts
    8

    < > Question

    Say there's a line that says "WHERE salary IS NULL and ROWNUM < 5"

    Question: Does this start at zero and count up to five, or does it start at 1 and count to 5?
    Does this return 4 rows or 5?
    Reply With Quote Reply With Quote
  2. 04-22-2003, 03:19 PM #2
    stecal's Avatar
    stecal
    stecal is offline Senior Advisor
    Join Date
    May 2002
    Posts
    2,645
    http://download-west.oracle.com/docs...ts6a.htm#33158
    Reply With Quote Reply With Quote
  3. 04-22-2003, 03:20 PM #3
    Rwbrown
    Rwbrown is offline Junior Member
    Join Date
    Apr 2003
    Posts
    8
    I have no way of testing this question right now. Help?
    Reply With Quote Reply With Quote
  4. 04-22-2003, 03:23 PM #4
    Rwbrown
    Rwbrown is offline Junior Member
    Join Date
    Apr 2003
    Posts
    8
    Stecal, Thank You very much! I was unsure whether or not the count started at one or zero. This is what I understood ROWNUM to be, but since it was generated by Oracle didn't know the count start.

    'ROWNUM' is actually a pseudo-column generated by Oracle that indicates the order in which the data was returned. The value of the pseudo-column is not physically stored anywhere but only generated as the result set is generated.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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