Jump to content

Deyan8777

New Members
  • Posts

    2
  • Joined

  • Last visited

Deyan8777's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. i am stuck with this from 2 weeks ....can't find a solution, i found only with subselect....that i dont need
  2. 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
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.