Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select 4 rows, calculate stddev, take next 4 rows, calculate stddev

Status
Not open for further replies.

hudo

Programmer
Joined
Dec 4, 2003
Messages
94
Location
DE
Hello,

I'd like to do some statistic calculations.
For example to select the first 4 values from emp.sal, calculate STDDEV and VARIANCE, MIN
and MAX from these values,
than take the next 4 values from emp.sal, calculate STDDEV,VARIANCE,MIN,MAX,
than take the next 4 values and so on..

How can this be done ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top