Question

What are SQL functions? Describe in brief different types of SQL functions?

Answer 1

SQL Functions are a very powerful feature of SQL. These functions can take arguments but always return some value. There are two distinct types of SQL functions available. They are:

Single-Row functions: These functions operate on a single row to give one result per row.

Types of Single-Row functions are:

1. Character
2. Number
3. Date
4. Conversion
5. General
6. Multiple-Row functions: These functions operate on groups of rows to give one result per group of rows.

Types of Multiple-Row functions:

1. avg
2. count
3. max
4. min
5. sum
6. stddev
7. variance