VAR_SAMP function in Oracle

VAR_SAMP is one of the vital Analytic functions of Oracle. It is used to get the sample variance of a set of numbers. The VAR_SAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.


VAR_SAMP ( expression )

expression: It is used to specify the numerical expression to be used for calculation.


select VAR_SAMP (marks)
from students;

Here, the sample variance will be returned for the field called ‘marks’ of the ‘students’ table.