You are viewing a single comment's thread. Return to all comments →
MS-SQL
select top 1 (salary*months) as totalsal , count(employee_id) as cnt from employee group by (salary*months) order by (salary*months) desc
Seems like cookies are disabled on this browser, please enable them to open this website
Top Earners
You are viewing a single comment's thread. Return to all comments →
MS-SQL
select top 1 (salary*months) as totalsal , count(employee_id) as cnt from employee group by (salary*months) order by (salary*months) desc