What are aggregate functions in MySQL?

1.	What are aggregate functions in MySQL?
Answer» The aggregate FUNCTION performs a calculation on a set of VALUES and RETURNS a single value. It ignores NULL values when it performs calculation except for the COUNT function. MySQL provides various aggregate FUNCTIONS that include AVG(), COUNT(), SUM(), MIN(), MAX(). Also Read: What Are The Aggregate Functions in MySQL

Answer»

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

MySQL provides various aggregate FUNCTIONS that include AVG(), COUNT(), SUM(), MIN(), MAX().

Also Read: What Are The Aggregate Functions in MySQL

Discussion

No Comment Found

Related InterviewSolutions

__PHP_Incomplete_Class when do we get this? How to solve this problem?
How to expose private members when JSON encoding an object?
How can you access class members as array indexes?
How to pass out of scope variables to a callback function?
What are promises?
What are generators?
What is a resource? Which functions return/create resource?
Does PHP support event loop? If yes give some example.
What is OPcache?
How does the method overriding work with Traits?

What are aggregate functions in MySQL?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment