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

Question

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

KnowledgeBoat · Accepted Answer

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

Computer Science

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

SQL Queries

Answer

Output

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.