Not A Group By Expression
Posted on 2012-03-20
My query is below and I had it working but then modified it and now I am getting not a group by expression. I have googled and know what it means but I cannot see what I have done wrong below. Someone please help. Either point out the error or maybe tell me how to rewrite? Thanks.
select cor.error_desc, sum(cor.error_count), trunc(sum(cor.error_count)/(d.errorcount) * 100, 2) MYTABLE cor, (select sum(c.error_count) as errorcount from MYTABLE c where c.las='ANAME' and trunc(c.date_stamp) between to_date('3/1/2012', 'MM/DD/YYYY') and to_date('3/31/2012', 'MM/DD/YYYY') and c.major is not null) d where cor.las='ANAME' and trunc(cor.date_stamp) between to_date('3/1/2012', 'MM/DD/YYYY') and to_date('3/31/2012', 'MM/DD/YYYY') and cor.major is not null group by cor.error_desc