Koen Verbeeck (10/25/2013)
It might depend on indexes, the physical location of the rows in the pages and how the query plan is generated.Let's assume it's "random" unless you specify another column in your ORDER BY.
By the way, that's a pretty lousy ID 🙂
I second that the ID is pretty lousy:-)
However, I do have a question here. Eve though a clustered index sorts the data physically but still it is recommended to use an Order by clause always if the data needs to be sorted. so what do you mean by 'depends on indexes'. Kindly explain.
Thanks
Chandan Jha