Quiz-Results

Tag: quiz-results

ORDER BY, OFFSET, and Fetch in TSQL

ORDER BY, OFFSET, and Fetch in TSQL

By Kendra Little on June 29, 2018

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.

Continue reading

AVG() in TSQL: Watch Your Data Types

AVG() in TSQL: Watch Your Data Types

This week’s Quizletter featured a quiz on using the AVG() function in SQL Server.

I was inspired to write this quiz because I’ve been teaching “TSQL School” each week. When we covered aggregate functions, I remembered how tricksy AVG() can be.

Continue reading