I am posting 30 difficult SQL queries in 30 days. Follow me on “Srinimf” to grab these queries.
How to select employee name who does not have supervisor?
WHERE ESUPER IS NULL;
The above results all the employees who does not have supervisor.
NULL means no value. SQL uses decision based on TRUE, FALSE, UNKNOWN