**Contents**show

## What are the different types of SQL functions?

**Categories of SQL Functions**

- Single row function: Single row functions are those functions which return a single result row for each row of queried table or view. …
- Aggregate function: …
- Analytic function: …
- Model Functions: …
- User defined function: …
- Scalar functions:

## What are different types of functions in SQL and explain with suitable examples?

Aggregate SQL Functions

Function | Description |
---|---|

SUM() | Used to return the sum of a group of values. |

COUNT() | Returns the number of rows either based on a condition, or without a condition. |

AVG() | Used to calculate the average value of a numeric column. |

MIN() | This function returns the minimum value of a column. |

## What is difference between function and procedure?

Function is used to calculate something from a given input. Hence it got its name from Mathematics. While procedure is the set of commands, which are executed in a order.

## What is difference between stored procedure and function?

The function must return a value but in Stored Procedure it is **optional**. Even a procedure can return zero or n values. Functions can have only input parameters for it whereas Procedures can have input or output parameters. Functions can be called from Procedure whereas Procedures cannot be called from a Function.

## What are SQL procedures?

What is a procedure in SQL? A procedure in SQL (often referred to as stored procedure), is **a reusable unit that encapsulates the specific business logic of the application**. A SQL procedure is a group of SQL statements and logic, compiled and stored together to perform a specific task.

## WHAT IS function and procedure in SQL?

“A procedures or function is a group or set of SQL and PL/SQL statements **that perform a specific task**.” A function and procedure is a named PL/SQL Block which is similar . The major difference between a procedure and a function is, a function must always return a value, but a procedure may or may not return a value.

## What is data integrity in SQL?

Data Integrity is **used to maintain Accuracy and consistency of data in the Table**. Data Integrity is used to maintain accuracy and consistency of data in a table.