This content has been marked as final. Show 3 replies
just don't expect the results to come out in the sequence odd, even, odd, even .....
The answer you have marked correct needs two order by clauses to guarantee that.
The inner select will return rows in a random order, potentially different each time you run it. The outer select may not return rows in the same order as the inner one.