top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is ROWNUM in Oracle?

+1 vote
319 views
What is ROWNUM in Oracle?
posted Feb 9, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

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