Check sibling questions

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

 

Are ads bothering you?


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 - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.