/SQL/How to use aggregate functions in sql

How to use aggregate functions in sql

This is the example.Aggregate function is AVG.production.products is the table.

SELECT
    AVG(list_price) avg_product_price
FROM
    production.products;

Source: sqlservertutorial.net

Aggregate function in sql

• Single Row Functions:(Lower, Upper, Substr, Length)
function that will run for each row and 
return value for each row.

Multiple Row Functions (Group functions, Aggregate functions):
(Count, MIN , MAX, AVG, SUM)
will run for multiple rows and return a single value

Similar codes

5 votes191 views1 answer
Oracle drop index if exists
SQL
0 vote167 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote186 views1 answer
Query builder doctrien return sql
SQL
0 vote164 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote172 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote168 views1 answer
How to install sql in anaconda
SQL
7 votes177 views1 answer
Xampp reset mysql
SQL
0 vote178 views1 answer
Oracle locked objects
SQL
0 vote176 views1 answer
Mssql view column data type
SQL
2 votes173 views1 answer
Mysql create user with remote access
SQL