Skip to content
Advertisement

Finding employees who are not managers

I have a table where we have staff_id and manager_id. Attached screenshot.

I found managers by using this query:

How do I pull a list of employees who are not managers?

My sample table

My sample table

Advertisement

Answer

use not exists

if you use not in then do null chechk

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