Top "Ora-00937" questions

ORA-00937: Not a single-group group function

How to resolve ORA-00937: not a single-group group function when calculating percentage?

I'm trying to get a percentage of the itemid that are available in a certain area. Using my query, I …

Read More
sql oracle ora-00937
Select earliest hired employee from employee table

I have an employee table where the fields are: first_name, last_name, hire_date, salary, department_id, department_name, …

Read More
sql oracle ora-00937
Show sum of all for every record

Say you have table of some items with these two columns: ItemName Price ....where ItemName is unique. How do you …

Read More
sql oracle ora-00937