What are aggregate functions in mysql?



What are aggregate functions in mysql?..

Answer / hrindows@gmail.com

The MySQL 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.
MYSQL Aggregrate functions are listed below:
 AVG()
 COUNT()
 SUM()
 MIN()
 MAX()

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

1 Answers  


How to determine the location of the data directory?

0 Answers  


What is truncate in mysql?

0 Answers  


Write a query to create a database and a table?

0 Answers  


What is the latest version of mysql?

0 Answers  






What is row level locking in access?

0 Answers  


What is database url for mysql?

0 Answers  


What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 Answers  


How to change the database engine in mysql?

0 Answers  


What is pdo :: fetch_assoc?

0 Answers  


Is mysql workbench a dbms?

0 Answers  


Is primary key auto increment?

0 Answers  


Categories