understanding how much stable the system is
RahulAgrawal 22 May 2013 09:13
Select year,month,count(1) as Project_count,sum(ocount) as Object_count from (
SELECT distinct B.PROJECTNAME,TO_CHAR(B.LASTUPDDTTM ,'yyyy' ) as year,
TO_CHAR(B.LASTUPDDTTM ,'mm' ) as month,
count(1) over (Partition by B.PROJECTNAME) as oCount
FROM PSPROJECTITEM A,
PSPROJECTDEFN B
WHERE ( A.PROJECTNAME = B.PROJECTNAME )
and B.LASTUPDDTTM >sysdate-365)
group by year,month order by year,month