What is ROWNUM in Oracle?

+1 vote

336 views

oracle
sql

posted Feb 9, 2015 by Suchithra

Share this question

Your comment on this post:

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

1 Answer

+1 vote

Best answer

ROWNUM is a Psuedo-Column that returns the the sequence of the row returned. You cannot use it to limit rows since rownum is only incremented after a row is returned in the result set

answer Feb 10, 2015 by Arun Gowda

Your comment on this answer:

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.

Your answer

Preview

Email me at this address if my answer is selected or commented on:Email me if my answer is selected or commented on

Privacy: Your email address will only be used for sending these notifications.

Anti-spam verification:

To avoid this verification in future, please log in or register.