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

Standered deviation of last 20 values in the database column

P: 20
hi all
i want to calculate the Standered deviation of last 20 values in the database column,how can i do it using DTDEV function of SQL.
Reply me
Thanks in advance to all.
Oct 8 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418

You enter in query design view, assign the table on which you want to do the calculation...

Choose the column that contains the values for the standart deviation...

Press the sigma bouton /sum, total/

Instaed group By select Stdev

It's ready to see the deviation!

Switch to datasheet view for this!

Oct 8 '06 #2

Post your reply

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