Will sql query without order by return same result set on multiple runs?
Hi,
I've a sql without order by and I restrict the number of rows to 100 max by rownum < 100. Now the question is, If the data set on which this sql runs, does not change, will the sql return the same result set on multiple execution?
For example, there are 150 rows, and the sql returns 100 rows because of rownum < 100. Now on executing the same sql multiple times, will I get the same set of 100 rows? or it could be any of the 150? On what bases these the database engine sort and return data when no order by clause is provided?
Thank you for your time.
-Hozy