CodesJava

Easy learning with example program codes

VAR_POP function in Oracle

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

Syntax:

VAR_POP ( expression )

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

Example:

select VAR_POP (marks)
from students;

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

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status