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 -> help in writing an sql

help in writing an sql

From: Romi <romi.mht_at_gmail.com>
Date: 2 Feb 2005 00:41:33 -0800
Message-ID: <dd5edc55.0502020041.370d535@posting.google.com>


Hi,
I have a table tab1

sch_date date
sch_week number
sch_act char(1)

select * from tab1
sch_date sch_week sch_act

--------    --------   -------
02-Jan-05     1        X
02-Jan-05     1        Y
04-Jan-05     1        X
05-Jan-05     1        Y

I need to show this data in following format using a single sql statement :

Week Date X Y

-----    ---------  ---    --    
1        02-Jan-05   Yes   Yes   
1        04-Jan-05   Yes   No    
1        05-Jan-05   No    Yes   

The following sql shows me records for 02-JAn-05 in seperate lines which i need to show in same line as above.

select sch_week,trunc(sch_date),decode(sch_act,'X','Yes','No') "X", decode(sch_act,'Y','Yes','No') "Y" from tab1;

  SCH_WEEK TRUNC(SCH X Y

---------- --------- --- ---
         1 02-JAN-05 Yes No
         1 02-JAN-05 No  Yes
         1 04-JAN-05 Yes No
         1 05-JAN-05 No  Yes

could someone help please.

TIA,
Romi Received on Wed Feb 02 2005 - 02:41:33 CST

Original text of this message

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