rownum in Oracle
Here in this post, we will talk about the ROWNUM keyword in Oracle What is ROWNUM It is a pseudo column (not a real column) that is available in a query. ROWNUM is assigned the numbers 1, 2, 3, 4, … N, where N is the number of rows for the first, second, third…n records …