By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Using aggregate fucntion to calculate standard deviation

P: 1
How can i use aggregate function like count, sum and other to calculate standard deviation in SQL
Oct 14 '09 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
What do you have so far?


--- CK
Oct 14 '09 #2

Delerna
Expert 100+
P: 1,134
Use the SQL server STDEV function

Example from SQL Server help docs

STDEV
Returns the statistical standard deviation of all values in the given expression.

Expand|Select|Wrap|Line Numbers
  1. USE pubs
  2. SELECT STDEV(royalty)
  3. FROM titles
  4.  
Oct 14 '09 #3

nbiswas
100+
P: 149
It is STDEV as what Mr. Delerna replied.

Reref to this linkhttp://msdn.microsoft.com/en-us/library/ms190474.aspx for more info
Nov 9 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.