Advanced SQL – Window Functions

https://www.lynda.com/SQL-tutorials/Advanced-SQL-Window-Functions/2824360-2.html

Window functions are one of the most radical, fundamental enhancements to modern SQL. They allow access to neighboring rows without using subqueries, thus enabling amazing opportunities for concise, elegant, high-performing solutions.

 

• Introduction
• 1. Tools, Files, and Query Processing Review
• 2. Window Functions and the OVER Clause
• 3. Framing, Exclusions, and Shortcuts
• 4. Aggregate Window Functions
• 5. Rank and Distribution Window Functions
• 6. Offset Window Functions
• Conclusion

 TO MAC USERS: If RAR password doesn't work, use this archive program: 

RAR Expander 0.8.5 Beta 4  and extract password protected files without error.

 TO WIN USERS: If RAR password doesn't work, use this archive program: 

Latest Winrar  and extract password protected files without error.

 Gamystyle   |