SQL Queries 30 Days Challenge – Day 1

I am posting 30 difficult SQL queries in 30 days. Follow me on “Srinimf” to grab these queries.

Query:1

How to select employee name who does not have supervisor?

Solution:

SELECT ENAME,EMPNO

FROM EMP

WHERE ESUPER IS NULL;

The above results all the employees who does not have supervisor.

About NULL:

NULL means no value. SQL uses decision based on TRUE, FALSE, UNKNOWN