Yurttas/PL/DBL/mysql/F/01/00/Company-B/q10.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM q10.sql
 4REM
 5REM Find the company with the most employees.
 6REM
 7*/
 8
 9\. set-db.sql
10
11SELECT companyname
12FROM Works
13GROUP BY companyname
14HAVING COUNT(*) >= ALL (SELECT COUNT(*)
15                        FROM Works
16                        GROUP BY companyname);