Select max(count(*))
6106Oct 22 2001 — edited May 14 2013I need to select the count maximum of rows to a column number,
by example I want to see the count maximum of rows with status=3
and I see the status, How I can to do that?
I try to do 'select max(count(*)), status from jobs where Ncase=1
090015 group by status' and the error message follow is showing:
ERROR at line 1:
ORA-00937: not a single-group group function
why happen that? and How I can to resolve?
Thank by any idea.