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
select * from R where a in (select S.a from S)

Question

Examsnet · Accepted Answer

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

GATE Computer Science (CS) 2014 Shift 2 Solved Paper