Databases · Junior · Question 30 of 75

Which aggregate functions are standard in SQL?

Explanation

LENGTH, UPPER and TRIM are scalar functions: they work on each value, not on a group. PostgreSQL adds many more aggregates like string_agg and array_agg.

Further reading

Problem with a question

Databases · Junior · question 30

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.

Take this quiz