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

|

3258 Discussions

|

  • ayush_kurchania
     + 0 comments

    SELECT MAX(MONTHS * SALARY) AS TOTAL, COUNT(NAME) AS COUNT FROM Employee where MONTHS * SALARY = (SELECT MAX(MONTHS * SALARY) FROM employee)

    (SIMPLE WAY)

  • pvj_valadares
     + 0 comments
    SELECT
    months * salary AS ganhos,
    COUNT(*) AS total
FROM
    Employee
GROUP BY
    months * salary
HAVING
    ganhos = (SELECT MAX(months * salary) FROM Employee)

  • shivanandabagi41
     + 0 comments

    select salary*months as total_earnings,count(*) from Employee group by total_earnings order by total_earnings desc limit 1;

  • sudeshmahto520
     + 0 comments

    SELECT (salary*months) as earnings,count(*) FROM Employee group by earnings order by 1 desc limit 1;

  • SVVBathini
     + 0 comments

    For MySQL

    SELECT salary*months AS total_earnings, COUNT(*) FROM employee
GROUP BY 1
ORDER BY 1 DESC LIMIT 1;