Yurttas/PL/DBL/oracle/F/01/Company-B/q11.sql
Jump to navigation
Jump to search
1REM
2REM q11.sql
3REM
4REM Find the company with the smallest payroll.
5REM
6
7SELECT companyname
8FROM Works
9GROUP BY companyname
10HAVING SUM(salary) <= ALL (SELECT SUM(salary)
11 FROM Works
12 GROUP BY companyname);