You are viewing a single comment's thread. Return to all comments →
MSSQL with total_sal as (select max(salary * months) as total_sal, count(*) as [no of employees] from employee group by salary * months) select top (1) total_sal, [no of employees] from total_sal order by total_sal 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 →