You are viewing a single comment's thread. Return to all comments →
for mssql select concat(max(months*salary),' ',count(*)) from employee where months*salary=(select max(months*salary) from employee)
Top Earners
You are viewing a single comment's thread. Return to all comments →
for mssql select concat(max(months*salary),' ',count(*)) from employee where months*salary=(select max(months*salary) from employee)