What are the some basics function in SQL?

Data Science, AI and ML
,
1

Sql Question

2

Some basics function of SQL are
AVG,COUNT,SUM,MAX,MIN

3

The built-in functions provided by SQL are the following: COUNT, SUM, AVG, MAX and MIN. These functions are aggregate functions, they perform calculations on the result-set and return the single value.

  • COUNT - counts the number of rows of a specified table
  • SUM - returns the sum of the result-set values
  • AVG - returns the average value of the result-set values
  • MAX - returns the maximum value of the result-set values
  • MIN - returns the minimum value of the result-set values