JOIN NOW

Computer Science

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

SQL Queries

2 Likes

Answer

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

Answered By

1 Like

Related Questions