What are aggregate functions in mysql?
- 1 Answers
- 1025 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 |
What is difference between schema and table?
What is normalization and list the different types of normalization?
What is the difference between heap table and temporary table?
What is a tinyint?
What is mysqli_connect_error ()?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
How can we find the number of rows in a table using MySQL?
Can mysql store files?
How internally data stores in MyISAM and INNODB table types?
What is dblink?
How to install mysql?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
