Aggregate Functions

Min and Max Aggregate Functions in TSQL

by SteveStedman
December 22, 2022December 16, 2022
Classes, TSQL

Here is a sample query using the MIN and MAX functions in T-SQL: This query selects the minimum and maximum values for the Price column… Read More »Min and Max Aggregate Functions in TSQL

SQL Sunday Word Scramble

by SteveStedman
February 8, 2015February 7, 2015
Analytic TSQL, SQL Sunday

SQL Server – TSQL Analytics Word Search Find the following words in the word scramble above. TOP RANK DENSE_RANK ROW_NUMBER NTILE OVER LAG LEAD FIRST_VALUE… Read More »SQL Sunday Word Scramble

TOP, Ranking, NTILE, and Aggregate Functions

by SteveStedman
February 5, 2015July 11, 2015
Analytic TSQL, Classes

Continuing our weekly SQL Query Training for the 70-461 exam preparation, at Steve Stedman, sharing this weeks class with the world. Free SQL Query… Read More »TOP, Ranking, NTILE, and Aggregate Functions