0
30kviews
Explain aggregate functions with example
1 Answer
| written 7.3 years ago by |
SQL provides various aggregate functions which can summarize data of given table.
| Sid | SName | Marks |
|---|---|---|
| 1 | John | 90 |
| 2 | Martin | 80 |
| 3 | Carol | 89 |
| 4 | Jack | 99 |
| 5 | Rose | 88 |
| 6 | Mary | 90 |
1.COUNT()
• This function is used to calculate number of rows in a table selected by query. …