We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Top Earners
  5. Discussions

Top Earners

Sort by

recency

|

3435 Discussions

|

  • ayeayeaye
     + 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;

  • ayushrai0529
     + 0 comments

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

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

  • tejalpisal30
     + 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

  • vyoma_patel
     + 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;