Question:
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: Apr 24, 2025
- max(col)
- min(col)
- round(n, d)
- count(*)
Hide Solution
Verified By Collegedunia
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
0
Top Questions on SQL
- Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 values and D2 takes 2 values, and all combinations of these values are present in the table Facts. How many tuples are there in the result of the following query? \[ \text{SELECT D1, D2, sum(val)} \] \[ \text{FROM Facts} \] \[ \text{GROUP BY CUBE (D1, D2);} \]
On a relation named Loan of a bank:
- 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? - SQL applies conditions on the groups through ________ clause after groups have been formed?
- What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)?
View More Questions
Questions Asked in CUET exam
- The components of computerized accounting system refer to:
- CUET (UG) - 2024
- Using a Computerized Accounting System
- S and T are partners in a firm sharing profits in the ratio of 3:2. They admit U as a new partner. S surrenders \(\frac{1}{4}\) of his share and T surrenders 1/3 of his share in favour of U. Sacrificing ratio of S and T will be:
Choose the correct answer from the options given below:- CUET (UG) - 2024
- Profit sharing ratio
- Calculate goodwill on the basis of two years’ purchase of average profit of the last four years. Profit/Loss of the last four years is given below:
• 2020: 1,00,000
• 2021: 1,50,000
• 2022: 2,20,000
• 2023: (70,000)
Additional information: Closing Stock of the year 2022 was overvalued by 20,000.- CUET (UG) - 2024
- Profit and Loss Account
- A die is rolled thrice. What is the probability of getting a number greater than $4$ in the first and second throws and a number less than $4$ in the third throw?
- CUET (UG) - 2024
- Probability
- Six people E, H, K, M, S, and U are seated in a circle facing the center. U and H are immediate neighbors of M. E is the only person sitting between K and S. H is to the immediate right of S. Who is to the immediate right of U?
- CUET (UG) - 2024
- Statements and Inferences
View More Questions