fail A - because in the subquery exist condition referenced to main table but not subquery table. By other words, in the subquery not exist limitation for fetching rows and subquery return more than one row
A,B,D give the same result. But C is different
I suggest C
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
alic_alex
Highly Voted 1 year, 10 months agosalander71
Most Recent 3 months, 1 week agoTomZh
6 months, 4 weeks ago7dc4ae8
7 months, 1 week agoArslanAltaf
8 months, 2 weeks ago[Removed]
9 months, 3 weeks agodeepzsiva
12 months agoArth1989
1 year agolucemqy
1 year, 2 months agozouve
1 year, 6 months agoRik92
1 year, 9 months agoDarnun
1 year, 9 months agoBeesho
1 year, 10 months agojfc1
1 year, 10 months ago