Selecting values greater than ROWNUM,as opposed to less than,or less than or equal to ROWNUM,will return no rows whatsoever.

Name: Selecting values greater than ROWNUM,as opposed to less than,or less than or equal to ROWNUM,will return no rows whatsoever.
Brand: Quizplus
Rating: 4.9 (30 reviews)

Question

Quizplus · Accepted Answer

This is because ROWNUM is generated based on the order in which Oracle retrieves the rows, so if we select values greater than ROWNUM, no rows will satisfy that condition as ROWNUM is already higher than those values.

Selecting Values Greater Than ROWNUM,as Opposed to Less Than,or Less