| Parameter | Type | Description |
|---|---|---|
value | decimal, double | The values from which to take the standard deviation. |
Returns: decimal
Example
query:
SELECT STDEV(sales_pipeline.close_value)
FROM sales_pipeline
WHERE deal_stage = "Won"
result:
| stdev |
|---|
| 2544.18 |
Population Standard Deviation.
| Parameter | Type | Description |
|---|---|---|
value | decimal, double | The values from which to take the standard deviation. |
query:
SELECT STDEV(sales_pipeline.close_value)
FROM sales_pipeline
WHERE deal_stage = "Won"
result:
| stdev |
|---|
| 2544.18 |