in Databases
240 views
0 votes
0 votes

Consider the following relations and query given below:
Emp( Id, Name, Sex, Salary)
Proj(No, Name, Dno) and
Works_on(No, IDs) contains atleast one tuples.

Consider the following query:

Select Name
From Emp
Where NOT Exists ((Select No
                 From Proj where Dno = 106)
             EXCEPT (select No from
                 works_on where Id = IDs));

 

What does this query return?

in Databases
240 views

1 comment

@learner what the options given?
0
0

1 Answer

0 votes
0 votes
Employee name who works on all the project of department number 106

1 comment

source?
0
0