Topics

• Getting started with Microsoft SQL Server
• UPDATE
• GROUP BY
• Window Functions
• Common Table Expressions
• ORDER BY

Examples

• Adding the total rows selected to every row
• UPDATE All Rows
• ORDER BY with complex logic