CBSE Class 12 Informatics Practices Question 58 of 90

Querying Using SQL — Question 8

Back to all questions
8
Question

Question 8

What are aggregate functions? What is their use? Give some examples.

Answer

Aggregate functions in SQL work with data from multiple rows at a time and return a single aggregated value. They are used to perform calculations across multiple rows and return a summary result for that group.

Examples of aggregate functions include SUM(), COUNT(), MAX(), MIN(), AVG() etc.