Question 4Write a query to display the name, job title and salary of employee who do not have manager.

Question

Accepted Answer

SELECT ENAME, JOB, SAL
FROM empl
WHERE MGR IS NULL ;Output+-------+-----------+------+
| ENAME | JOB       | SAL  |
+-------+-----------+------+
| AMIR  | PRESIDENT | 5000 |
+-------+-----------+------+

Simple Queries in SQL — Question 4

Question 4

Output