retagged by
560 views
1 votes
1 votes

The innermost query select those projects which have employees working under it; hence NOT EXISITS will select those Pid's that do not have any employees working under it. The second innermost query will select those Pid's which doesn't have any employee working under it and goes by the name 'Database'. Say 3 and 4 are such Pid's. Now, Pid 2 is also named as database. Hence the outermost query will select 2 also along with other pid's. Doesn't that make option c correct?

retagged by

2 Answers

Best answer
3 votes
3 votes

do for one of EID once whole query then second EID these are corelated queries. 

So A is corrct

selected by
0 votes
0 votes
I am getting answer as

All the employees above 30.

Related questions

1 votes
1 votes
2 answers
2
Arnabi asked Oct 17, 2017
829 views
3 votes
3 votes
2 answers
4
shikharV asked Dec 8, 2015
1,132 views
Use the following tables for the below queries wherever table $1$ and table $2$ are used:Select *From Table 1Where not exists (Select $T_{2}B$ From Table 2 where $T_{2}B ...