Top Earners

Sort by

recency

|

3435 Discussions

|

  • + 0 comments

    SELECT sal, cnt FROM ( SELECT MAX(salary * months) sal, COUNT(employee_id) cnt from Employee Group By salary * months Order By salary * months Desc )d WHERE ROWNUM = 1;

  • + 0 comments

    select max(salary*months), count(employee_id) from employee where salary*months in (select max(salary*months) from employee)

  • + 0 comments
    SELECT TOP 1 salary*months, SPACE(2), COUNT(employee_id)
    FROM EMPLOYEE
    GROUP BY salary*months 
    ORDER BY salary*months DESC
    
  • + 0 comments

    WITH EARNING AS (SELECT *, (MONTHS*SALARY) AS 'TOTAL_EARNING' FROM EMPLOYEE) SELECT TOP 1 TOTAL_EARNING, COUNT(*) FROM EARNING GROUP BY TOTAL_EARNING ORDER BY 1 DESC

  • + 0 comments
    /*
    Enter your query here.
    MYSQL */
    
    SELECT MAX(SALARY*MONTHS) AS EARNINGS, COUNT(NAME) FROM EMPLOYEE
    GROUP BY (SALARY*MONTHS)
    ORDER BY (SALARY*MONTHS) DESC
    LIMIT 1;