Search the Community
Showing results for tags 'select max values'.
i got table employees with ID , NAME , SALARY i need to select all employees having max salary. i need to self join the table and i must not use subselect. For now only 2 employees got the max salary how to select both of them select e.name, max(e.salary) from employees as e left join employees as es on e.id=es.id this only select one of the employees having max salary i need and the other one