Top Earners

Sort by

recency

|

3479 Discussions

|

  • + 0 comments
    SELECT
    CONCAT(
       MAX(salary*months)
        ,' '
        ,COUNT(name)
          )
    FROM Employee
    WHERE salary*months =  (SELECT MAX(salary*months) FROM Employee);
    
  • + 0 comments

    SELECT MAX(salary * months), COUNT(*) FROM Employee WHERE salary * months = (SELECT MAX(salary * months) FROM Employee);

  • + 0 comments

    For MySQL Platform

    SELECT salary*months AS total_earnings, COUNT(*) FROM employee
    GROUP BY 1
    ORDER BY 1 DESC LIMIT 1;
    
  • + 0 comments
    SELECT MAX(salary*months),COUNT(salary) FROM Employee
    WHERE salary*months>=(SELECT MAX(salary*months) FROM Employee)
    
  • + 0 comments

    For MS SQL Server:

    SELECT TOP 1 (Salary * Months) as EARNINGS, COUNT(name) FROM Employee GROUP BY Salary, Months ORDER BY EARNINGS DESC