/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

0 vote130 views1 answer
List in one column mysql
SQL
1 vote120 views2 answers
Mysql order by date asc null last
SQL
2 votes251 views2 answers
MySql FULL OUTER JOIN
SQL
1 vote115 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote126 views2 answers
How to find sql server agent jobs related to a database
SQL
5 votes118 views2 answers
Postgres update with if condition query
SQL
0 vote124 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote112 views1 answer
Query on date sqlite flutter
SQL
0 vote124 views1 answer
Python sql last insertend
SQL
0 vote131 views1 answer
Create-table-with-index-organization
SQL