---
schema_version: "1"
id: 66d406aa54be81358990201a448a2ed348679ecf1bea3887542d27935a4c2d5b
title: var_samp()
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-aggregate-var-samp.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-aggregate-var-samp.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 1dccf0174e561ad1528afb425580f04394914b65e3a86c2b21fa4e873654745a
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# var_samp()

Returns the sample variance of the values in a field. Accepts measure fields as input. This function does not accept expressions.

`var_samp()` follows this syntax.

```nolang
SELECT var_samp(FIELD1, FIELD2)
FROM DATASET;
```