Question 3 of 32beginner💡 UnderstandShort Answer2 marks

Site any two differences between Single Row Functions and Aggregate Functions.

Correct Answer

Two differences between Single Row Functions and Aggregate Functions are:

  1. Single Row Functions operate on a single row at a time and return one result per row, whereas Aggregate Functions operate on groups of rows and return one result for a group of rows.

  2. Single Row Functions can be used in Select, Where, and Order by clause, whereas Aggregate Functions can be used in the select clause only.

Exercise: EXERCISE | Q: 1(c) | (Page 46)
For More Understanding

Explanation

The answer is derived from Table 9.16 in the textbook which clearly lists the differences between Single Row Functions and Multiple Row (Aggregate) Functions. The first difference focuses on how they operate (single row vs groups of rows) and their output (one result per row vs one result per group). The second difference highlights the clauses where these functions can be used. Students can also mention examples as a valid difference - Math, String and Date functions for Single Row, and Max(), Min(), Avg(), Sum(), Count() for Aggregate functions.

PreviousNext