Yurttas/PL/DBL/oracle/F/01/Company-B/q11.sql

From ZCubes Wiki
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);