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.