![]() |
|||
|
![]() |
||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
![]() |
|
Looking for the original pages? (formerly called "Morgan's Library") You can find them here.
![]() Term: STDDEV_POP
Definition: STDDEV_POP( [ DISTINCT | ALL ] expression ) Analytic Function: STDDEV_POP( [ DISTINCT | ALL ] expression ) [ OVER ( analytical_clause ) ] Example Usage: The SQL statement below returns the population standard deviation of the Quantity field from ORDERS table: SELECT STDDEV_POP(QTY) The SQL statement below returns the cumulative population standard deviation of the quantity over the orders against each date. SELECT DT,STDDEV_POP(QTY) OVER (ORDER BY dt) Related Links: Related Code Snippets:
|
![]() |
Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us | 16 users online © 2009 psoug.org |