What is aggregate and scalar functions in DBMS?

Aggregate functions are the calculations on the set or group of value, and they return a single value.

The aggregate functions are :-

• AVG-- to calculate the average of the data.
• MAX-- to find the maximum value among the given data.
• MIN-- to find the minimum value among the given data.
• SUM-- It returns the SUM of the data.
• COUNT( )--It returns the total number of value in the particular column in the table.
• COUNT (*)-- It returns the number of rows in the table even the NULL value.

Scalar Functions are the calculations on the data given by the user, and they return a single value.

The scalar functions are :-

• UCASE()-- it converts the data into the CAPITAL LETTERS
• LCASE()-- it translates the data into the SMALL LETTERS
• MID()-- it extracts the particular text from the given text
• LEN()—it returns the length of the text in the text files
• ROUND()-- it round of the decimal number for ex-5.5 to 6
• NOW()-- it returns the date and time of the system in use
• FORMAT()-- it formats the field as per the requirement.