What are aggregate functions? What is their use? Give some examples.

Q. What are aggregate functions? What is their use? Give some examples.

Answer =

The function that work on whole records of one column at a time is called aggregate functions.

Or in other word Function that works on aggregate of rows. A multiple row function.

Uses:-
An aggregate Function retrieve a single value after performing calculation on set of values.

Example :-
SUM (),MIN(),MAX(),COUNT(),AVG() etc.