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

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

--- CK
Oct 14 '09 #2

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

Example from SQL Server help docs

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
Oct 14 '09 #3

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

Reref to this link for more info
Nov 9 '09 #4

Post your reply

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