The relation R(A,B) may have duplicate tuples. Choose the query that create non-duplicated results, regardless of what tuples R contains?

The relation R(A,B) may have duplicate tuples. Choose the query that create non-duplicated results, regardless of what tuples R contains? 




A.SELECT A, B FROM R
B.SELECT A, B FROM R GROUP BY A, B
C.SELECT A FROM R WHERE A NOT IN (SELECT B FROM R)
D.SELECT TOP 3 A, B FROM R



Answer: B


Learn More :