ORACLE SQL ROWNUM execution order
Posted
by iwan
on Stack Overflow
See other posts from Stack Overflow
or by iwan
Published on 2010-06-11T02:34:31Z
Indexed on
2010/06/11
2:42 UTC
Read the original article
Hit count: 325
Dear expert,
in Oracle SQL, there is a possible criteria called rownum. Can i confirm that rownum will be executed at last as just a limit for number of records return? or could it be executed first, before other WHERE SQL criteria (let's if we put rownum prior to the others)?
© Stack Overflow or respective owner
