Computer Science

Site any two differences between Single Row Functions and Aggregate Functions.

3 Likes

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

1 Like