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
What is the difference between primary key and secondary key?
What database does facebook use?
What is cardinality in db?
What are the different stages in 'data warehousing'?
What is cliques? What is vdisk and how it will communicate with physical data storage at the time of data retrieval through amp?
What is meant by database system?
What do you understand by cursor?
Explain the Logical Schema of Database
how Data is stored in a file so that Direct Searching can be performed
What do you understand by functional dependency?
Explain the difference between two and three-tier architectures.
What are fact tables and dimension tables ? What is dimensional modeling and star schema design
What are the 3 types of relationships in a database?
Why is the use of dbms recommended? Explain by listing some of its major advantages.
State at least four kinds of indexing?