Skip to content
Advertisement

List the emps whose sal > his Manager but less than other Managers

List the emps whose sal > his Manager but salary less than other Managers

Table

Query

Result: null columns. There are 4 managers in total 2,4 ,6 and 3. Here clearly emp_id 2 Zaid is a person whose salary 620 is greater than his manager’s salary emp_id 4 which is 600 but less than all other managers emp_id 6 and 3. So I should get that result but getting nothing.

Expected result

Advertisement

Answer

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement