Please explain what are aggregate functions?
Submitted by: MuhammadAggregate functions perform calculations on a set of values and return a single value. The common aggregate functions are:
☛ COUNT (counts the number of rows in the table)
☛ SUM (returns the sum of all values of a numeric column)
☛ AVG (returns the average of all values of a numeric column)
☛ MIN (returns the lowest value of a numeric column)
☛ MAX (returns the highest value of a numeric column).
Aggregate functions are frequently used in combination with the GROUP BY statement.
Submitted by: Muhammad
☛ COUNT (counts the number of rows in the table)
☛ SUM (returns the sum of all values of a numeric column)
☛ AVG (returns the average of all values of a numeric column)
☛ MIN (returns the lowest value of a numeric column)
☛ MAX (returns the highest value of a numeric column).
Aggregate functions are frequently used in combination with the GROUP BY statement.
Submitted by: Muhammad
Read Online Database Analyst Job Interview Questions And Answers
Top Database Analyst Questions
☺ | Tell me what is the IN operator? |
☺ | Please explain what is the difference between UNION and UNION ALL? |
☺ | Explain me about a time when you could not meet a deadline? |
☺ | Tell us why did you go into data analysis? |
☺ | Tell us when might someone denormalize their data? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |