Answer
Aggregate functions calculate values over multiple rows, such as COUNT, SUM, AVG, MIN, and MAX.
Quick Answer
Aggregate functions compute a single value from multiple rows. COUNT(*): total row count. COUNT(col): non-NULL values count. SUM(col): total of values. AVG(col): average. MAX(col)/MIN(col): largest/smallest value. GROUP_CONCAT(col): combines values into a string. Used with GROUP BY to compute per-group summaries. NULL values are ignored by all aggregates except COUNT(*).
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ