santosh asp.net tutorial

There are two type of SQL Functions.

A. Aggregate Functions:-SQL aggregate functions return a single value, calculated from values in a column.

1. FIRST():-It returns the first value
2. LAST():-It returns the last value
3. AVG():-It returns the average value
4. COUNT():- It returns the number of rows
5. MAX():- It returns the largest value
6. MIN():- It returns the smallest value
7. SUM():- It returns the sum

B. Scalar functions:-SQL scalar functions return a single value, based on the input value.

1. UCASE():- It converts a field to upper case
2. LCASE():- It converts a field to lower case
3. MID():- It extract characters from a text field
4. LEN():- It returns the length of a text field
5. ROUND():- It rounds a numeric field to the number of decimals specified
6. NOW():- It returns the current system date and time
7. FORMAT():- It formats how a field is to be displayed