What are the Common SQL Functions Used for Data Aggregation?
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
Can you have more than one cursor open at any one time in a program ?
What is database transaction?
Explain issues for database performance.
What is dbms and its advantages?
What is the full meaning of dbms?
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
Describe the purposes and advantages stored procedure?
How are exceptions handled in pl/sql? Give some of the internal exceptions name?
What is the meaning of flat file database?
Can you drop all the columns of a table ?
What is structure of dbms?
What is rdbms and its features?
What are the different technologies used to access Database from Visual Basic?
Have you written applications to retrieve stored images in a table?
What is the best database management system?