Introduction of Aggregate function in SQL
In this article I am going to explain how to work with aggregate function in sql.
Introduction
There are two type of function in SQL which are used to manipulate data.
- System Define Function
- User Define Function
User define function are created by user according to need to performer some specific task but system define function are predefined we can not change their functionality. SQL Server provide lots of inbuilt function to manipulate data.
Here I am explaining name of aggregate function
- AVG (expression)
- SUM (expression)
- MIN (expression)
- MAX (expression)
- COUNT (expression)
Aggregate function are part of these inbuilt function which are used to performer a calculation on the values in a set of selected rows. A SELECT statement which uses these aggregate function known as summary query.
Statement that create mcninvoice table
Statements that insert data in mcninvoice table
Statement that is used to fetch data from mcninvoice table
Statement that use aggregate function