GATE Papers >> CSE >> 2014 >> Question No 164

Question No. 164 CSE | GATE 2014

SQL allows duplicate tuples in relations, and correspondingly defines the multiplicity of tuples in the result of joins. Which one of the following queries always gives the same answer as the nested query shown below:

select * from R where a in (select S.a from S)

Answer : (C) select R.* from R,(select distinct a from S) as S1 where R.a=S1.a

No Comments
Leave a comment