Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help in writing an sql
A simple query to have the above result could be
select sch_wkid, sch_date, decode(sum(xc),0,'No', 'Yes'),
decode(sum(yc),0,'No', 'Yes')
from
(select sch_wkid, sch_date, decode(sch_act,'X',1,0) XC,
decode(sch_act,'Y',1,0) YC
from tab1)
group by sch_wkid, sch_date
Received on Wed Feb 02 2005 - 22:26:51 CST