w3resource

SQL exercises on employee Database: List the employee name, and job_name who are not working under a manager

SQL employee Database: Exercise-26 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

26. From the following table, write a SQL query to find those employees who are not working under a manager. Return employee name, job name.

Sample table: employees


Pictorial Presentation:

SQL exercises on employee Database: List the employee name, and job_name who are not working under a manager

Sample Solution:

SELECT e.emp_name,
       e.job_name
FROM employees e
WHERE manager_id IS NULL;

Sample Output:

 emp_name     | job_name
--------------+--------------
  KAYLING     | PRESIDENT

Relational Algebra Expression:

Relational Algebra Expression: List the employee name, and job_name who are not working under a manager.

Relational Algebra Tree:

Relational Algebra Tree: List the employee name, and job_name who are not working under a manager.

Practice Online


Sample Database: employee

employee database structure

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find those employees who joined before 1st April 1991. Return employee ID, employee name, hire date and salary.
Next: From the following table, write a SQL query to find those employees who joined on 1st May 91. Return complete information about the employees.

What is the difficulty level of this exercise?