Version1.0
Download0
Stock
Total Files1
Size1,022.00 KB
Create DateFebruary 11, 2017
Last UpdatedFebruary 11, 2017

Aggregations functions are used to perform calculations on a group of values to return a single value. In this lab, we will look into various basic and advanced aggregations. In the first exercise, we will look into various basic aggregate functions such as SUM, MAX, MIN, COUNT, STDEV, VAR, AVG. In the second exercise, we will learn to perform some advanced aggregations using CUBE and ROLLUP operators. In the third exercise, we will to learn to use GROUPING SETS and GROUPING_ID to perform grouping. In the fourth and final exercise, we will learn to use OVER clause to perform aggregations.


File
SQL Server Aggregations

Subscribe to Download
Calling Web Service From SSIS
New Security Features in SQL Server 2016