Hi guys
I have below mentioned query in sql.... but i need to create report using that sql...... can anyone help me how to create answer using this sql.
select p.mnth_yr,
count(p.code)
from f_fact P
where substr(mnth_yr,4)='2009'
and p.st='L'
and not exists (select 1 from f_fact x
where nvl(x.p_cd,'Z') = nvl(p.p_cd,'Z')
and x.code = p.code
and x.st in ('A','B'))
group by p.mnth_yr
Thanks
Edited by: user11933655 on 09-Apr-2010 03:37