SQL Queries 30 Days Challenge – Day 1

Digital Marketing
Digital Marketing

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

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.