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 -> grouping query

grouping query

From: rj <rjeena_at_gmail.com>
Date: 27 Mar 2006 02:08:55 -0800
Message-ID: <1143454135.713714.90830@j33g2000cwa.googlegroups.com>


Hi

i have a test table with many diff columns.Im using oracle 9i

i gna jus name 3 columns Name, Start_time, Identifier

example of data:

NAME START_TIME IDENTIFIER

Talk show          05:00:00                P
A                      05:15:00                I
B                      05:20:00                I
C                      05:22:00                I
D                     05:24:00                 I
Ridzys Chicken  06:00:00               S
talk show            06:10:00               P
A                      06:15:00                I
B                      06:20:00                I
C                      06:22:00                I
D                     06:24:00                 I
Ridzys Chicken  06:30:00               S

how do i find P insert all its column data into a new table. then i need
only the start_time for the I and then the entries for S to look as follows.

Name Start_Time Identifier

Talk show             05:00:00                 P
E                         05:15:00                 I
Ridzys Chicken     09:00:00                S
talk show              06:10:00                 P
z                          06:15:00                 I
Ridzys Chicken     06:30:00                S


the table has lots of identifiers i need to group them all as above.

Thanks in advance :) Received on Mon Mar 27 2006 - 04:08:55 CST

Original text of this message

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