In https://gateoverflow.in/285452/Go2019-flt1-27 , wouldn’t the query in question return distinct values, while query in option B can duplicate return values?
Ex:
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-except-and-intersect-transact-sql#:~:text=INTERSECT%20returns%20distinct%20rows%20that,the%20same%20in%20all%20queries.
64.3k questions
77.9k answers
244k comments
80.0k users