The MySQL aggregate function performs a calculation on a set of values, and

What are aggregate functions in mysql?

Question Posted / hrindows@gmail.com

1 Answers
1297 Views
I also Faced
E-Mail Answers

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 View All Answers

Please Help Members By Posting Answers For Below Questions

How to represent ENUMs and SETs internally?

1085

Explain csv tables.

934

How many sql ddl commands are supported by 'mysql'?

1074

Is sql and mysql same?

871

How can you add and remove any column of a table?

880

What is the use of mysqli_connect in php?

854

What is mysql aggregate functions? Explain

1013

What is the limit of mysql database?

905

How to Join tables on common columns.

1100

How to delete a trigger in mysql?

878

How to start mysql server?

993

What is difference between schema and table?

865

Explain the difference between mysql and mysql interfaces in php?

1008

What are the 5 r's of managing behaviors?

1031

How do I start mysql in ubuntu?

955