Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Built-in Functions/ Aggregate Functions/ stddev_samp
Updated on 2023-10-25 GMT+08:00
View PDF

stddev_samp

This function is used to return the sample deviation of a specified column.

Syntax

stddev_samp(col)

Parameters

Table 1 Parameter

Parameter

Mandatory

Description

col

Yes

Columns with a data type of numeric. If the values are of any other type, NULL is returned.

Return Values

The return value is of the DOUBLE type.

Example Code

  • Calculates the sample covariance between the inventory (items) and the price of all offerings. An example command is as follows: 
    select covar_samp(items,price) from warehouse;

    The command output is as follows:

    _c0        
1.242355
  • When used with group by, it groups all offerings by warehouse (warehourseId) and returns the sample covariance between the inventory (items) and the price of offerings within each group. An example command is as follows: 
    select warehourseId, covar_samp(items,price) from warehourse group by warehourseId;

    The command output is as follows:

    warehouseId _c1        
city1    1.03124   
city2    1.03344   
city3    1.33425
Parent topic: Aggregate Functions