aggregate function

Aggregate functions in DBMS take multiple rows from the table and return a value according to the query.
All the aggregate functions are used in Select statement.

Syntax: 
SELECT <FUNCTION NAME> (<PARAMETER>) FROM <TABLE NAME>

AVG Function

This function returns the average value of the numeric column that is supplied as a parameter.
Example: Write a query to select average salary from employee table.


Comments

Popular posts from this blog

Lab Network 2024

Step to publish your static html web page to GitHub

Tutorial OOP(reversion java)