Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> rolling group by
I have a table of data with a single row for each day. I would like to get a rolling 30-day stddev for a particular column. That is, a stddev for the 30 days prior to each day. The sql will return a 30 days of data. Is this possible to do in single select statement? Any help is greatly appreciated. Thanks.
Dave Received on Wed Sep 20 2000 - 17:58:15 CDT