Question:medium
Which of the following is not an aggregate function?
Which of the following is not an aggregate function?
Show Hint
Aggregate functions in SQL include "SUM", "AVG", "MAX", "MIN", and "COUNT", which work on groups of rows to return a single value.
Updated On: Feb 13, 2026
- max(col)
- min(col)
- round(n, d)
- count(*)
Show Solution
The Correct Option is C
Solution and Explanation
Aggregate functions in SQL are used to perform calculations on a set of values to return a single value. Functions like "max()", "min()", and "count()" are aggregate functions. However, "round(n, d)" is not an aggregate function. It is used to round a number to a specified number of decimal places.
Was this answer helpful?
0
Top Questions on SQL
- Describe about any two DML commands of SQL.
- Briefly explain about any two column constraints used in SQL.
- Given the table facts: \[ \text{facts (D1, D2, val)} \] with the following data:
Consider the following SQL query:
What is the total number of rows produced? On a relation named Loan of a bank:
- Want to practice more? Try solving extra ecology questions todayView All Questions