Does a SELECT query always return rows in the same order? Table with clustered index Does a SELECT query always return rows in the same order? Table with clustered index sql-server sql-server

Does a SELECT query always return rows in the same order? Table with clustered index


The order of the returned rows will not always be the same unless you explicitly state so with the ORDER BY clause. So, no.

And no; just because your 1000 queries have returned the same order it's no guarantee the 1001th query will be in the same order.