Tag: NTILE

SQL Sunday Word Scramble

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

Tagged with: , , , , , , ,

TSQL Queries – Using NTILE

NTILE is a SQL Server function that can be called in a TSQL Query. This is part of the free sql query training to prepare for the Microsoft 70-461 queries exam. Here is a video presentation on using the TSQL

Tagged with: , ,

SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs

The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next week Aaron Buma and I will be presenting Set Operators, Derived Tables and CTEs. The live

Tagged with: , , ,

TOP, Ranking, NTILE, and Aggregate Functions

  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 training.     Here is the video of the training on TOP, Ranking, NTILE, and

Tagged with: , , ,
Top