Computer Science
Site any two differences between Single Row Functions and Aggregate Functions.
SQL Queries
2 Likes
Answer
Two differences between Single Row Functions and Aggregate Functions are:
| Single Row Functions | Aggregate Functions |
|---|---|
| Single row functions operate on individual rows and return a single value per row. | Aggregate functions operate on groups of rows and return a single result for each group. |
| It can be used in SELECT, WHERE, and ORDER BY clause. | It can be used in the SELECT clause only. |
Answered By
2 Likes