Database Developer Question: Download Questions PDF
Tell me what are aggregate functions in SQL?
Answer:
SQL aggregate functions return a single value, calculated from values in a column. Some of the aggregate functions in SQL are as follows
☛ AVG() – This function returns the average value
☛ COUNT() – This function returns the number of rows
☛ MAX() – This function returns the largest value
☛ MIN() – This function returns the smallest value
☛ ROUND() – This function rounds a numeric field to the number of decimals specified
☛ SUM() – This function returns the sum
☛ AVG() – This function returns the average value
☛ COUNT() – This function returns the number of rows
☛ MAX() – This function returns the largest value
☛ MIN() – This function returns the smallest value
☛ ROUND() – This function rounds a numeric field to the number of decimals specified
☛ SUM() – This function returns the sum
Download Database Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell us what is the difference between Delete, Truncate and Drop command? | Tell us what do you mean by table and field in SQL? |