ORA-00937 not a single group funtion
660881Jan 8 2009 — edited Jan 8 2009hi to all,
im trying to run this sql statement in toad but i received an error : ORA-00937 not a single group funtion
select count(*) ----e.g table 1
(select count(*) from prc100 where prc100.work_date=uncoil_prc.work_date) ----table 2
from uncoil_prc
where uncoil_prc.work_date between '21-dec-2008' and '21-dec-2008'
what im trying to do is counting only the rows of a table per day:
possible ouput:
table1 table2 table 3
100 98 100 and so on,,,,,( in just one line...)
is there something wrong:? Pls. help me