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
Write a query to display details of employees who are not getting commission from table Empl.
Write a query to display employee name and salary of those employee who don't have their salary in the range of 2500 to 4000.
Write a query to display the name of employee whose name contains 'A' as third alphabet.
Write a query to display the name of employee whose name contains 'T' as the last alphabet.