in Databases
212 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

in Databases
by
212 views

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 in Databases Jan 25, 2023
240 views
Overflow04 asked in Databases Jan 25, 2023
240 views
0 votes
0 votes
1 answer
4