I have a list of companies with which I need to find the most employees. I am trying to do the varations of the below but I keep getting wierd errors.
select max(count (cs480.works.ename)) from cs480.works group by cs480.works.cname;
Using this I can return the actual largest number of the company with the most employees but I cant figure out how to return the company's name without returning the actuall number any ideas?
select max(count (cs480.works.ename)) from cs480.works group by cs480.works.cname;
Using this I can return the actual largest number of the company with the most employees but I cant figure out how to return the company's name without returning the actuall number any ideas?