Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Pivot table
Using Oracle 8.0.4 on Windows NT 4.0 I have a table with a structure
like this:
DT C1 C2 C3 C4 C5 C6 ------------------------------------- 01-15-98,00:00 01-15-98,00:01 01-15-98,00:02 .....
The table contains measured values with a sample rate of about 1 Minute. For statistics within a defined intervall (DT between lower and upper bound) I need a result which looks like this:
COLUMN MEAN MIN MAX STDDEV SUM
How can this be achieved with a SQL select statement?
Thanx in advance
Martin
--
![]() |
![]() |