444 views

1 Answer

0 votes
0 votes
both the queries will return the same result as in first query it is easily visible that it is intersection and in query 2 nested query 2 will return all p tuples and nested query 1 will return tuples of r which is not similar to tuples return by nested query 2 and finally main query will return all those tuples which are common in both the relations

and your answer is yes it will eliminate as it will only return the intersected part which is present in both.

Related questions

1 votes
1 votes
1 answer
1
Sajal Mallick asked Nov 5, 2023
336 views
Unique not null is equivalent to primary key.Relational Algebra and SQL has same expressive power.Which of the above statements are False?
1 votes
1 votes
1 answer
3
amitqy asked Nov 17, 2018
483 views
0 votes
0 votes
0 answers
4
Harsh Kumar asked Dec 11, 2018
492 views
Can primary keys be updated using sql update query?Is such a query accepted/rejected?