Question

write a note on SQI functions​

Answer 1

A function is a set of SQL statements that perform a specific task. ... Next time instead of rewriting the SQL, you can simply call that function. A function accepts inputs in the form of parameters and returns a value. SQL Server comes with a set of built-in functions that perform a variety of tasks

Answer 2

Answer:

SQL has many built-in functions for performing calculations on data.

...

SQL Functions

AVG() - Returns the average value.

COUNT() - Returns the number of rows.

FIRST() - Returns the first value.

LAST() - Returns the last value.

MAX() - Returns the largest value.

MIN() - Returns the smallest value.

SUM() - Returns the sum.