Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a "Default Order By Column" in SQL Server?

When I execute a query like SELECT col1, col2, col3 FROM table, it gets sorted by the primary key ascending.

I'm just wondering if there is a way to specify a different column, like ORDER BY CreatedDate DESC if there is no Order By clause?

I doubt it (since it would be very unintuitive, but just wondering anyway.

like image 413
Michael Stum Avatar asked Apr 11 '11 23:04

Michael Stum


1 Answers

No. Any ordering you see is an artifact of the query optimizer's strategy. Relational theory forbids that there is any implicit ordering of any set of data.

You can't even count on the same ordering next time for the same query because the optimizer strategy depends on the context and the data which might change.

like image 71
dkretz Avatar answered Sep 25 '22 21:09

dkretz