209 views
0 votes
0 votes

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: 

A B C
a1 4000 2500
a2 4000 2500
a1 4200 2500

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

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
1
0 votes
0 votes
0 answers
3
Overflow04 asked Jan 25, 2023
235 views
Please explain option c.
0 votes
0 votes
1 answer
4
Overflow04 asked Nov 29, 2022
244 views
In Query1, how mid is projected from did.?????????/