Yurttas/PL/DBL/oracle/F/01/Company-B/q10.sql
Jump to navigation
Jump to search
1REM
2REM q10.sql
3REM
4REM Find the company with the most employees.
5REM
6
7
8SELECT companyname
9FROM Works
10GROUP BY companyname
11HAVING COUNT(*) >= ALL (SELECT COUNT(*)
12 FROM Works
13 GROUP BY companyname);