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 better saving files in database or in file system?
What is database host?
Can we pass RECORD GROUP between FORMS ?
What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?
What are the benefits of modeling?
What does fill factor concept mean with respect to indexes?
What do you understand by proactive, retroactive and simultaneous update?
Why is it better to use an Integrity Constraint to validate data ?
Explain what is an Exception ?
Define weak entity set.
What is the default '-sort' order for a sql?
What are 3 types of databases?
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)