Multiple choice technology databases

What is true about group functions ?

  1. You can use group functions in any clause of a select statement

  2. You can use group functions only in the column list of the SELECT statement by grouping on the single row columns

  3. You can pass column names, expressions, constants or functions as parameters to a group function

  4. You cannot group the rows of a table by more than one column while using group functions
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Group functions, such as SUM or AVG, accept columns, expressions, constants, or other functions as arguments. They cannot be used in any clause (like the WHERE clause) and can group by multiple columns, making the other options incorrect descriptions of SQL group function behavior.

Keep practicing — related questions