Explain Aggregate functions are available there in SQL?

1.	Explain Aggregate functions are available there in SQL?
Answer» The aggregate function performs a calculation on a set of values, and it RETURNS a single value as output. It ignores NULL values when it performs calculation except for the COUNT function. SQL PROVIDES many aggregate functions that are listed below. AVG() COUNT() SUM() MIN() MAX() etc

Answer»

The aggregate function performs a calculation on a set of values, and it RETURNS a single value as output. It ignores NULL values when it performs calculation except for the COUNT function.

SQL PROVIDES many aggregate functions that are listed below.

AVG()
COUNT()
SUM()
MIN()
MAX() etc

Discussion

No Comment Found

Related InterviewSolutions

What has stored procedures in SQL and how we can use it?
How to use distinct and count in SQL query? Explain
Explain CLAUSE in SQL?
Write a query to find the names of users that begin with "um" in SQL?
Explain the difference between DROP and TRUNCATE commands in SQL?
Write a query to display the current date in SQL?
Explain Foreign key in SQL?
Explain Unique key in SQL.
Explain table and field in SQL?
What is a Database? Explain

Explain Aggregate functions are available there in SQL?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment