/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 vote310 views1 answer
Online sql testing tool
SQL
2 votes318 views1 answer
How to find constraints on a table in oracle
SQL
1 vote334 views1 answer
Setval pgsql
SQL
0 vote294 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote335 views1 answer
Sql get year from datetime field
SQL
4 votes301 views1 answer
Wilayah indonesia sql
SQL
1 vote330 views1 answer
Where database run
SQL
2 votes298 views2 answers
Postgres set user as superuser
SQL
0 vote319 views1 answer
Create table with float datatype in sql server
SQL
0 vote359 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL