What do you mean by Functions? Write down the purpose of all the functions like SUM, AVERAGE, COUNT, MAXIMUM, MINIMUM with example.
Answers
Answered by
0
Answer:
Those are called aggregate functions.
It retrieve a single value after performing a calculation on a set of values.
It ignores all null values.
sum : sum of all rows of specific column ex : sum of salaries.
avg : avg of all rows of column ex: avg salary
count: count the number of rows.ex: number of employees with sal>10000
max: maximum of all rows ex: max salary
min ex: min salary
Similar questions