Question:
Explain the use of any three aggregate functions in SQL.
Explain the use of any three aggregate functions in SQL.
Show Hint
Use SUM, AVG, and COUNT to perform quick calculations on large datasets in SQL.
Updated On: Jul 14, 2025
Hide Solution
Verified By Collegedunia
Solution and Explanation
Aggregate functions in SQL perform a calculation on a set of values and return a single value.
They are widely used in data analysis, reporting, and summarization.
Three common aggregate functions are:
(i) SUM(): This function adds up all values in a numeric column.
Example: SELECT SUM(salary) FROM employees; returns the total salary of all employees.
(ii) AVG(): Computes the average value of a numeric column.
Example: SELECT AVG(marks) FROM students; gives the average marks of all students.
(iii) COUNT(): Returns the number of rows or entries in a column.
Example: SELECT COUNT(*) FROM orders; counts the total number of orders.
These functions are often used with GROUP BY and HAVING clauses for advanced data analysis.
They are widely used in data analysis, reporting, and summarization.
Three common aggregate functions are:
(i) SUM(): This function adds up all values in a numeric column.
Example: SELECT SUM(salary) FROM employees; returns the total salary of all employees.
(ii) AVG(): Computes the average value of a numeric column.
Example: SELECT AVG(marks) FROM students; gives the average marks of all students.
(iii) COUNT(): Returns the number of rows or entries in a column.
Example: SELECT COUNT(*) FROM orders; counts the total number of orders.
These functions are often used with GROUP BY and HAVING clauses for advanced data analysis.
Was this answer helpful?
0
0
Top Questions on SQL
- Consider the given table GARMENT:
+--------+--------------+------+--------+-------+ | GCODE | GNAME | SIZE | COLOUR | PRICE | +--------+--------------+------+--------+-------+ | 111 | TShirt | XL | Red | 1400 | | 112 | Jeans | L | Blue | 1600 | | 113 | Skirt | M | Black | 1100 | | 114 | Ladies Jacket| XL | Blue | 4000 | | 115 | Trousers | L | Brown | 1500 | | 116 | Ladies Top | L | Pink | 1200 | +--------+--------------+------+--------+-------+
Write SQL commands for the following: (a) To display names of those garments that are available in ‘L’ size.
(b) To change the colour of garments with code as 115 to “Orange”.
(c) To add a new row with the following data:
GCODE = 117, GNAME = Kurta, SIZE = M, COLOUR = White, PRICE = 1000
(d) To remove the column ‘COLOUR’ from the table ‘GARMENT’. - What is the purpose of % and _ (underscore) characters used with LIKE operator in SQL?
- ................ keyword is used in SELECT statement along with column name to display duplicate values once in the result of an SQL query.
- Kritika did not use ASC or DESC keyword with ORDER BY clause. By default in which order will the result of the query be displayed?
- Write a function
Delete_Theatre()to input the value of Th_ID from the user and permanently delete the corresponding record from the THEATRE table in the CINEMA database.
Given:
Host: localhost, User: root, Password: Ex2025
View More Questions
Questions Asked in CBSE CLASS XII exam
- Solve for \( x \), \[ 2 \tan^{-1} x + \sin^{-1} \left( \frac{2x}{1 + x^2} \right) = 4\sqrt{3} \]
- CBSE CLASS XII - 2025
- Trigonometric Functions
- Let \( A = \begin{bmatrix} 1 & -2 & -1 \\ 0 & 4 & -1 \\ -3 & 2 & 1 \end{bmatrix}, B = \begin{bmatrix} -5 \\ -2 \end{bmatrix}, C = [9 \ \ 7], \) which of the following is defined?
- What is so ironical about Sam reaching the third level?
- CBSE CLASS XII - 2025
- Literature
- If $P(A) = \frac{1}{7}$, $P(B) = \frac{5}{7}$ and $P(A \cap B) = \frac{4}{7}$, then $P(A | B)$ is:
- CBSE CLASS XII - 2025
- Probability
- Solve the differential equation \( 2(y + 3) - xy \frac{dy}{dx} = 0 \); given \( y(1) = -2 \).
- CBSE CLASS XII - 2025
- Differential Equations
View More Questions