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. Practice
  2. SQL
  3. Aggregation
  4. Top Earners
  5. Discussions

Top Earners

  • hbautista + 1 comment

    Sql server:

    select top 1 months * salary as earnings, count (*) from employee group by months * salary order by 1 desc

    • Lehonti + 0 comments

      Thanks

      SELECT
    TOP 1 Months * Salary AS Earnings,
    COUNT(*)
FROM
    Employee
GROUP BY
    Months * Salary
ORDER BY
    Earnings DESC
;