Question

Select the suitable option for retrieving all the employees who have a manager?

Select one:
O select empname, manager id from employee where manager id is NULL VALUE;
O select empname, manager_id from employee where manager id is NOT NULL;
O select empname, manager id from employee where manager_id NULL;
select empname, manager_id from employee where manager_id is NULL;​

Answer 1

Answer:

O select empname, manager id from employee where manager id is NULL

Answer 2

The correct answer is :

Select empname, manager_id from employee where manager_id is NULL;​

SQL Queries :

• With one or even more databases, the Following SQL operation delivers a result set of records. A SELECT command pulls zero or perhaps more rows through one or even more MySql database or network views. The SELECT clause is a collection of variables or SQL statements that the query should produce.

• In SQL, the FROM statement is used to specify a post statement. The sub-relation query is now being used as an up with the initial to which the outer search is applied.

• When collecting information from a single database or merging many tables, the Query language WHERE statement is used to set a constraint.