While we all know how to display a result in random order via newid() function, I wonder how the query engine interprets a GUID(result of newid), since ORDER BY statement expects a column list (or position)?
NOTE: And if the GUID somehow magically is converted to column position, this assumption is invalid for a table with single column, since it will return results in random order.
Thanks