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 |
How is oracle different from mysql?
Is mysql owned by oracle?
What are date and time data types in mysql?
What are features of mysql?
when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field
What is the maximum length of a table name, a database name, or a field name in MySQL?
What is heap table in mysql?
How can we optimize stored procedure?
What is a definer?
How to set the time zone for MySQL to particular country time?
What different Stored Objects are supported in MySQL?
What is the use of ENUM in MySQL?
Oracle (3259)
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)