Functions are a very powerful feature of SQL and can be used to do the following :
- Perform calculation on data.
- Modify individual data items
- Manipulate output for groups of rows.
- Format dates and numbers for display.
- Convert column data types.
Functions can be classified into two types -
- Single-row functions
- Multiple-row function
Single Row Functions : These functions operate on single rows only and return one result per row. The single row functions are categorized as follows.
- Character functions
- Date functions
- Mathematical functions
- Conversion functions.
- Special functions
- OLAP functions
No comments:
Post a Comment