Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project










FUNCTION: STDEVP
SELECT STDEVP(field) AS [expression]
FROM table
[WHERE ...]
[GROUPBY ...]
[HAVING ...]
 
The STDEVP function is one of the aggregate functions that are used to calculate statistical information for a specified numeric field in a query. The other aggregate functions are: AVG, COUNT, MAX, MIN, STDEV, SUM, VAR, VARP. Note that all of these functions return a single value.
 
The STDEVP function finds the standard deviation by using all of values in a field. In comaparison, the STDEV function only uses a protion, called a sample, of the values to calculate the standard deviation. There must be at least two values in the field or the standard deviation will not be calculated and a NULL value is returned.
 
This code finds the standard deviation of the age for all MediCare patients in a hospital and stores that information in DevAge.
 
SELECT STDEVP(Age) AS [DevAge]
FROM MediCarePatients

 


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information