order by query with group by
SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY SUM(Salary) DESC LIMIT 1;
SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY AVG(Salary) DESC LIMIT 1;
SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY Salary DESC LIMIT 1;
how above three queries are different? please advise
SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY AVG(Salary) DESC LIMIT 1;
SELECT Department, SUM(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY Salary DESC LIMIT 1;
how above three queries are different? please advise
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.