My most recent Quizletter featured a quiz on ORDER BY in TSQL, complete with questions on the OFFSET and FETCH clauses which we got in SQL Server 2012.
One great thing about teaching TSQL School is that it reminds me of these cool options that can be easy to forget.
I recently got a great question: if I order by a column where all rows in that column have the same value, will SQL Server then order the results by the clustered index key?
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.