What are aggregate functions in mysql?
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 |
If we use sum function in mysql, does it return sum of that row or for that column?
What is mysql optimization?
How does mysql store data?
How to use rank function in mysql?
Is sql and mysql same?
How do you create a primary key?
What is difference b/w composit key n primary key and forigion key?
What is deterministic in mysql?
Will mysql remain free?
Can we use mysql and mysqli together?
What is max connections in mysql?
Write a command to view mysql database table structure?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)