You are viewing a single comment's thread. Return to all comments →
Why doesn't this work?
select max(months*salary),count(months*salary=(select max(months*salary) from employee)) from employee;
while this does:-
select 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 →
Why doesn't this work?
select max(months*salary),count(months*salary=(select max(months*salary) from employee)) from employee;
while this does:-