![]() |
|||
|
![]() |
||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||
![]() |
|
Looking for the original pages? (formerly called "Morgan's Library") You can find them here.
![]() Term: STDDEV_SAMP
Definition: STDDEV_SAMP( [ DISTINCT | ALL ] expression ) Analytic Function: STDDEV_SAMP( [ 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_SAMP(QTY) The SQL statement below returns the cumulative population standard deviation of the quantity over the orders against each date. SELECT DT,STDDEV_SAMP(QTY) OVER (ORDER BY DT) Related Links: Related Code Snippets:
|
![]() |
Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us | 13 users online © 2009 psoug.org |