SQL Aggregate functions like SQL MAX, SQL MIN, SQL COUNT And AVERAGE function

Published: 20 September 2011
on channel: baghul

28,042

https://sqlserver2014tutorial.com/

SQL Aggregate Functions are necessary to summarize numerical data in a SqL Server database. We have already looked at other transact SQl statements like SELECT and UPDATE SQL statements. Those typically are used to return rows of data that matches the criteria in the WHERE clause. SQL statements using aggregate functions like MIN, COUNT, AVG, SUM or MAX however return just one value after sql server has already applied the aggregation and summarized the data. In this manner MS 2008 aGgregate fUnctions perform their operation across multiple rows of data.

For today's discussion we are going to look at AdventureWorks2008 sample database in SQL Server 2008. There are a number of SQL aggregate functions including SQL min, max, avg, sum, group by, count functions

Visit our other sites:
https://www.learningcomputer.com
https://datatechnologyllc.com
https://sqlserver2014tutorial.com/

On this page of the site you can watch the video online SQL Aggregate functions like SQL MAX, SQL MIN, SQL COUNT And AVERAGE function with a duration of hours minute second in good quality, which was uploaded by the user baghul 20 September 2011, share the link with friends and acquaintances, this video has already been watched 28,042 times on youtube and it was liked by 38 viewers. Enjoy your viewing!

13,912

323