| SQLTutorials | |
| Powered By PhICK1.com | |
SQL Aggregate FunctionSQL Aggregate Function is built-in functions for counting and calculation (perform a calculation on a set of values and return a single value)Syntax for built-in SQL functions is - SELECT function(column) FROM table
Table Name: A Below is Example for SQL built-in Function , together with SQL Statement and the answer. AVG - Average value of columns Select AVG(Salary) FROM A Value = 4675 COUNT - number of rows Select COUNT(*) FROM A Value = 4 SELECT COUNT (DISTINCT Salary) FROM CUSTOMERS Value = 3 MAX - Maximun or Highest number in a column SELECT MAX(Salary) FROM CUSTOMERS Value = 5000 MAX - Minimum or Lowest number in a column SELECT MIN(Salary) FROM CUSTOMERS Value = 4000 SUM - Total number in a column SELECT SUM(Salary) FROM CUSTOMERS Value = 18500 powered by www.pHick1.com |
|