Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> help in writing an sql
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