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 |
Why is the use of dbms recommended? Explain by listing some of its major advantages.
What are the five steps of data modeling?
What is user and end user?
can Constraints cannot be exported through EXPORT command ?
2 Answers Grasim, Oracle, Suvidha,
Can we attach the same List of Values to different fields in Design time ?
What do you mean by denormalization?
What are the key constraints in dbms?
What are the steps to follow when preparing to create a table?
What is the maximum line size that dbms_output can handle?
Who introduced dbms?
Where is the data stored in a database?
What are the different types of database keys?
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)