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.

Suggest An Answer

No suggestions avaliable!