> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oxla.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL Functions

In this section, we will understand how functions work in Oxla, how to create a function command, learn about inputs and return types and explore various functions usage.

The following table summarizes the functions supported by Oxla:

| <div align="left"> Function Name </div>                                                  | <div align="left"> Description </div>                                                                                           |
| :--------------------------------------------------------------------------------------- | :------------------------------------------------------------------------------------------------------------------------------ |
| [BOOLEAN FUNCTIONS](/sql-reference/sql-functions/boolean-functions/if-function)          | Evaluate logical conditions and return `TRUE`, `FALSE` OR `NULL`                                                                |
| [MATH FUNCTIONS](/sql-reference/sql-functions/math-functions/overview)                   | Perform mathematical operations on numeric data, such as rounding, exponentiation calculation                                   |
| [STRING FUNCTIONS](/sql-reference/sql-functions/string-functions/overview)               | Manipulate string data for text processing, including concatenation, substring extraction and case conversion                   |
| [TIMESTAMP FUNCTIONS](/sql-reference/sql-functions/timestamp-functions/overview)         | Handle data and time values including extracting components, adding intervals and comparing timestamps                          |
| [TRIGONOMETRIC FUNCTIONS](/sql-reference/sql-functions/trigonometric-functions/overview) | Perform calculations using trigonometric ratios, such as sine, cosine and tangent                                               |
| [JSON FUNCTIONS](/sql-reference/sql-functions/json-functions/overview)                   | Manipulate and query JSON data stored in the database, including extracting values and creating JSON objects                    |
| [AGGREGATE FUNCTIONS](/sql-reference/sql-functions/aggregate-functions/overview)         | Summarize a set of values and return a single result, such as calculating sums, averages and counts                             |
| [WINDOW FUNCTIONS](/sql-reference/sql-functions/window-functions/overview)               | Operate over a subset of rows defined by a windowing clause, enabling ranking, aggregation and row numbering within result sets |
| [OTHER FUNCTIONS](/sql-reference/sql-functions/other-functions/overview)                 | Includes a variety of specialized functions not categorized elsewhere                                                           |