Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Pivot table

Pivot table

From: Ing. Martin Gamperl <mgampi_at_ibm.net>
Date: Sun, 19 Apr 1998 13:42:17 +0200
Message-ID: <3539E319.B76E6B43@ibm.net>


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



    C1
    C2
    C3
    C4

How can this be achieved with a SQL select statement?

Thanx in advance

Martin

--


Received on Sun Apr 19 1998 - 06:42:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US