SQL Query Training 70 461 TOP Ranking and Analytic functions
Additional Training: http://amzn.to/1RjjJCf
Shameless plug for new hobby: https://join.robinhood.com/aaronb5056 *
We cover features around the TOP(N) in your query, followed by using the RANK(), DENSE_RANK and ROW_NUMBER. Then on to Analytic Functions to help with your statistical analysis of data. Similar to aggregate functions, analytics functions compute over a group of rows with multiple results within each group. Learn how to properly use each of these analytics functions in combination with enhancements to the OVER clause. Learn the value of CUME_DIST and PERCENT_RANK in your analysis, use LAST_VALUE and FIRST_VALUE along with PERCENTILE_DISC, PERCENTILE_CONT, LEAD and LAG you can look at data in the next and previous row.