edited by
375 views
0 votes
0 votes

edited by

2 Answers

0 votes
0 votes
count(*) will result in zero value therfore 3 will be output and 3 record will be in final result.
0 votes
0 votes
When evaluating the subquery we will get a relation with just a single value 0 .Thus exists evaluates to true so ans is 3

Related questions

3 votes
3 votes
1 answer
1
0 votes
0 votes
0 answers
2
1 votes
1 votes
1 answer
3
Jason_Roy asked Jan 21, 2017
398 views
Correct Ans and how?
0 votes
0 votes
0 answers
4
Hradesh patel asked Jan 12, 2017
219 views
i think here in Q2 >> query write in wrong way.........here missing some brackets ??