What are the Common SQL Functions Used for Data Aggregation?



What are the Common SQL Functions Used for Data Aggregation?..

Answer / 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

More Database Management Interview Questions

Define dml compiler.

0 Answers  


What is SQL FORMS ?

1 Answers   CCIL,


Explain the functionality of dml compiler.

0 Answers  


What is openedge rdbms?

0 Answers  


What is like operator for and what are wild cards?

0 Answers  


Why not phenix, the zelinka/otwinoski libraries, etc?

0 Answers  


What is the importance of database in an organization?

0 Answers  


What are the applications of database?

0 Answers  


Explain bcnf (boyce-codd normal form)?

0 Answers  


what is s/w lifecycle?

5 Answers   IBM,


What is procedure in database?

0 Answers  


What are the uses of database management system?

0 Answers  


Categories