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.
- Prepare
- SQL
- Aggregation
- Top Earners
- Discussions
Top Earners
Top Earners
Sort by
recency
|
2954 Discussions
|
Please Login in order to post a comment
SELECT SALARY*MONTHS AS EARNING, COUNT(*) FROM EMPLOYEE GROUP BY EARNING ORDER BY EARNING DESC LIMIT 1;
SELECT (months*salary) as earnings, COUNT(*) FROM Employee GROUP BY earnings ORDER BY earnings DESC LIMIT 1;
MS SQL SERVER
select salary*months as earnings, count(*) from employee Group by earnings order by earnings DESC limit 1
MS SQL SERVER