Aggregating, windowing, and groupingPerforming aggregationsPerforming aggregations with groupingsWindowingNew T-SQL windowing featuresUsing the HAVING clauseUsing SQL Server temporary objectsCommon table expressionsTable variablesTemporary tablesHandling T-SQL errorsControlling flow keywordsBEGIN...ENDIF...ELSEWHILESummary