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

> Reference material for SQRT function

# SQRT

Returns the square root of a numeric expression.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
SQRT(<value>);
```

## Parameters

| Parameter | Description                                  | Supported input types |
| :-------- | :------------------------------------------- | :-------------------- |
| `<value>` | Value that the `SQRT` function is applied to | `DOUBLE PRECISION`    |

## Notes

* When input value is integer data type, it is implicitly converted to `DOUBLE PRECISION`.
* When input value is `NUMERIC`, the `SQRT` function returns an error.
* When input value is negative, the `SQRT` function returns an error.

## Return Types

`DOUBLE PRECISION`.

## Example

The following example returns the square root of 64:

<div className="query-window">
  ```
  SELECT SQRT(64);
  ```

  | sqrt <span>double</span> |
  | :----------------------- |
  | 8                        |

  <p><span>Rows: 1</span><span>Execution time: 5.22ms</span></p>
</div>
