What are the Common SQL Functions Used for Data Aggregation?
- 1 Answers
- 327 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
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 |
Post New Answer View All Answers
How to implement a database management system?
what is the age limit for groups1 examination
Explain database partitioning and its importance.
What do you understand by intension and extension?
What is end users in dbms?
What is foreign key in database?
What do you understand by data model?
What are the advantages of manual database?
What is 3nf in dbms?
What is a checkpoint in dbms and when does it occur?
Mention a query to calculate the even and odd records from a table
what are the differences between network and hierarchical database model?
What are the different levels of abstraction in the dbms?
Explain the terms database and dbms. Also, mention the different types of dbms.
How many types of data are there?
