ROWS – Steve Stedman

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

Rows and Range, Preceding and Following

by SteveStedman
April 11, 2013May 25, 2023
22 Comments
Analytic TSQL, SQL 2012, TSQL, TSQL 2012

SQL Server 2012 adds many new features to Transact SQL (T-SQL). One of my favorites is the Rows and Range enhancements to the over clause.… Read More »Rows and Range, Preceding and Following