What are the Common SQL Functions Used for Data Aggregation?
SUM(): Determines a numeric column's total sum.
AVG(): Determines a numeric column's average value.
COUNT(): Determines how many rows satisfy a certain criterion.
MIN(): Determines a column's lowest value.
MAX(): Determines a column's maximum value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Which is the best database?
What are the functions of database management system?
What is CRUD Operations?
Why not phenix, the zelinka/otwinoski libraries, etc?
Discuss transparent DBMS?
How do we select distinct values from a table?
Tell us about some Dot operator queries?
What is pcbs (program communication blocks)?
Is mysql a rdbms?
What is query in rdbms?
How to lock records in a table?
What is a string in database?
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)