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

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM q11.sql
 4REM
 5REM Find the company with the smallest payroll.
 6REM
 7*/
 8
 9SELECT companyname 
10FROM Works 
11GROUP BY companyname 
12HAVING SUM(salary) <= ALL (SELECT SUM(salary) 
13                           FROM Works 
14                           GROUP BY companyname);