Using multiple aggregate functions in one SQL query

Question

My table is as below

WORKS ( emp-name, comp-name, salary)

I want to find the comp-name which pays to lowest total salary to it's employees

I tries below query, but it gives SUM of salaries for all comp-name

SELECT  comp-name, MIN(sal) as lowest
FROM
(
    SELECT comp-name, SUM(salary) as sal from WORKS group by comp-name
)tmt group by comp-name;

How do I find only one company which pays lowest total salary.

Wait, no primary key ? I'll assume that e's are unique. If true, then should'nt it be select c,min(s) from words group by c — Erran Morad
– Erran Morad, Commented Oct 13, 2014 at 1:58

bobwienholt · Accepted Answer · 2014-10-13 02:42:34Z

1

You can use LIMIT to get only one company with lowest total salary , also need to need to sort in ascending order

     SELECT comp-name, 
     SUM(salary) as sal 
     from WORKS 
     group by comp-name
     Order by sal ASC
     LIMIT 1

bobwienholt

17.6k3 gold badges43 silver badges48 bronze badges

answered Oct 13, 2014 at 2:00

radar

13.4k2 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1