You are viewing a single comment's thread. Return to all comments →
Select MAX(salary*months), count(*)from Employee group by salary*months having salary*months=(Select MAX(salary*months)from Employee );
Top Earners
You are viewing a single comment's thread. Return to all comments →
Select MAX(salary*months), count(*)from Employee group by salary*months having salary*months=(Select MAX(salary*months)from Employee );