GATE Overflow Test Series | Databases | Test 1 | Question: 12
Consider the relations $R(A,B,C)$ and $S(B,C,D)$ and the following SQL queries. Select distinct $\ast$ from $R,S;$ Select distinct $\ast$ from $R,S$ where $R.C = S.C;$ Select distinct $\ast$ from $R,S$ where $R.C = S.C$ and $R.B = S.B;$ Select ... $i-b,ii-a,iii-d,iv-c$ $i-d,ii-a,iii-b,iv-c$ $i-c,ii-a,iii-b,iv-d$
Consider the relations $R(A,B,C)$ and $S(B,C,D)$ and the following SQL queries.Select distinct $\ast$ from $R,S;$Select distinct $\ast$ from $R,S$ where $R.C = S.C;$Selec...