Question 9 - Past Year - 1 Mark Questions - Chapter 9 - Structured Query Language

Last updated at April 16, 2024 by

This question asked in CBSE SQP-2021

Write any one aggregate function used in SQL.

 

Answer:

Aggregate functions are those functions which performs a calculation on a set of values and returns a single value.

One aggregate function used in SQL is COUNT( )

Aggregate function used in SQL are

Aggregate function

Description

AVG( )

Returns the average of a set of values .

SUM( )

Returns the sum of a set of values .

COUNT( )

Returns the number of rows that matches a specific criterion

MIN( )

Returns the minimum value in a set of values

MAX( )

Returns the maximum value in a set of values

 

Go Ad-free

Transcript

This question asked in CBSE SQP-2021 Write any one aggregate function used in SQL. Answer: Aggregate functions are those functions which performs a calculation on a set of values and returns a single value. One aggregate function used in SQL is COUNT( ) Aggregate function used in SQL are Aggregate function Description AVG( ) Returns the average of a set of values. SUM( ) Returns the sum of a set of values. COUNT( ) Returns the number of rows that matches a specific criterion MIN( ) Returns the minimum value in a set of values MAX( ) Returns the maximum value in a set of values

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo