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

|

3545 Discussions

|

  • rumshashaikh2812
     + 1 comment

    MySQL Code:

    SELECT (months * salary) AS EARNINGS, COUNT(*) FROM EMPLOYEE GROUP BY EARNINGS ORDER BY EARNINGS DESC LIMIT 1

  • mostafaelemam080
     + 0 comments

    Another solution using sub-Query not lisited in discussions

    SELECT max(salary*months) as max_salary , count(*) from employee where salary * months = ( SELECT max(salary*months) from employee
    )

  • isa_cmorija1
     + 0 comments
    SELECT salary*months, COUNT(*)
FROM employee
GROUP BY salary*months
ORDER BY salary*months DESC
LIMIT 1

  • hari33113
     + 0 comments

    SELECT concat(max(salary*months),' ',count(*)) from employee group by salary*months order by salary*months desc limit 1;

  • hemanth6_u
     + 0 comments

    SELECT (months*salary)as total_sal,count(*)as cnt from employee group by 1 order by 1 desc limit 1