What are aggregate functions?

SQL aggregates and GROUP BY · Freshers

Model answer

Functions that compute one value from many rows: COUNT, SUM, AVG, MIN and MAX. For example SELECT AVG(price) FROM products. Most aggregates ignore NULLs, except COUNT(*), which counts all rows.

Learn this topic

GROUP BY and HAVING: Summaries for Each Group in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions