Tag: ROWS

By Posted on Posted in Analytic TSQL, SQL Sunday No Comments Tagged with , , , , , , ,

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 LAST_VALUE PERCENT_RANK PERCENTILE_DISC PERCENTILE_CONT CUME_DIST PARTITION ROWS PRECEDING FOLLOWING UNBOUNDED   Download the Printable PDF of the Word Search. See Also TSQL Queries – Using NTILE TOP, Ranking, NTILE, and Aggregate Functions TSQL Analytics FREE …

SQL Sunday Word Scramble Read more »

By Posted on Posted in Analytic TSQL, SQL 2012, TSQL, TSQL 2012 22 Comments Tagged with , , , , , , , , , , ,

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. These enhancements are often times referred to as the windowing functions. Want to learn more about the windowing functions? Check out this aggregation class that I have created: Overview:ROWS PRECEDING, FOLLOWING, UNBOUNDED, refers to the …

Rows and Range, Preceding and Following Read more »