Functions (SQL)

SQL is having multiple inbuilt functions which help developers to z many complex situations in day to day life.

All the functions are divided in four categories.

1)      Row set Functions

2)      Aggregate Functions

3)      Ranking Functions

4)      Scalar Functions

Row set Functions

 Row set Function return an object that can be used like a table reference in a SQL statement.

Aggregate Functions

These functions operate on a collection of values but return a single and summarize value

Ranking Functions

These functions returns a ranking value for each row in a partition

Scalar Functions

Operate on a single value and return a single value. There are 12 different kinds of Scalar Functions available. We will study all in details and we will see the example also.

 In coming posts we will learn about above functions in detail with Example.

Happy Reading!!!!!!

 

Sanjay Bakshi

mesanjaybakshi@gmail.com