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 |
How to use multiple database server in back end ?
What are the three main types of models?
is it sufficient to normalize a database up to 3NF?
What are the restrictions applicable while creating views?
How do I create a database in access 2010?
Explain the concepts of a primary key and foreign key.
Explain the hierarchical database?
What is the most used database?
What file is read by ODBC to load drivers ?
where a Database Procedure is stored ?
Is there an example how to configure udfaccess setting in firebird.conf?
What is rdbms and also explain its components?
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)