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

Explain by listing some of dbms major advantages.

0 Answers  


Is the server accepting tcp ip connections on port 5432?

0 Answers  


What are the main components of a database system?

0 Answers  


what do u mean by implementation?

0 Answers  


What is the difference between horizontal and vertical partitioning?

0 Answers  


Write a query to create a duplicate table with and without data present?

0 Answers  


How do I check my drivers?

0 Answers  


Explain the architecture of reporting services?

0 Answers  


What is 2nf in dbms?

0 Answers  


Explain the importance of database partitioning.

0 Answers  


How to change database dialect?

0 Answers  


What are the four objectives of the selection of a data type?

0 Answers  


Categories