Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pippo1959
Starting Member
1 Post |
 Posted - 2009-10-22 : 12:06:34
|
| hi all, I'm new so be patient...I'm trying to get the following:I have a table with n values of weight, i need to get the same n values of stdev of the last x weight....e.g. with 100 weight values i need to get 100 average values an 100 stdev values referred to (each value) the last 10 values (mobile average and mobile stdev).sample query:select avg(weight) as Average, stdev(weight) as "Standard Deviation"from.....but i get always a NULL for stdev and the weight value for the average...I hope this is clear...thanks to all for any help. |
|
|
|
|
|
mobile standard deviatin and average