What are the Common SQL Functions Used for Data Aggregation?
- 1 Answers
- 355 Views
- I also Faced
- E-Mail Answers
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 |
What are the five important software components of a database management system?
How data are stored in database?
What is Two-Phase Commit ?
What is view dbms?
Explain about the case statement present in stored procedure?
Is it possible to declare or create a cursor for update of table? If no tell me why?
what is the difference between securityand protection in dbms?
What built in subprogram is used to manipulate images in image items ?
What is dbms_output put_line?
What are the 3 types of relationships in a database?
how to generate an auto incremental number in a ssis package?
What is query in rdbms?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
