What is aggregate and scalar functions in DBMS?

1.	What is aggregate and scalar functions in DBMS?
Answer» 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.

Answer»

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 :-

Discussion