/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

2 votes188 views1 answer
Oracle sql concatenate results into string
SQL
0 vote213 views1 answer
Delete a temporary table mysql
SQL
0 vote182 views1 answer
Java mysql date format
SQL
1 vote211 views3 answers
Mysql on delete set null
SQL
4 votes191 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote199 views1 answer
Running percentage of total postgres
SQL
0 vote245 views2 answers
Insert data into multiple tables mysql
SQL
4 votes197 views2 answers
Postgre sql create table
SQL
2 votes209 views2 answers
Postgres add column integer
SQL
1 vote197 views1 answer
Duplicating a MySQL table with all the data Command
SQL