Discussion Board

Wrong answer its UNION or you should have asked for common records in both queries. if query 1 gives A B and query 2 gives C D Intersect will give no result. Ashutosh 08-26-2017 04:49 AM

union Union returns all distinct rows that are in both queries. Union all returns all rows that are in both queries intersect returns rows that exist in both queries only if one is pedantic , technically this occurs in all three operators to some degree bernard 05-10-2017 01:52 PM

INTERSECT The INTERSECT operator returns rows that are retrieved by both queries. The UNION operator returns only distinct rows that appear in either result, while the UNION ALL operator returns all rows. The UNION ALL operator does not eliminate duplicate selected rows. Prajakta Pandit 02-14-2017 04:20 AM

Intersect Union returns rows that are retrieved by EITHER query - not both Greg 03-13-2015 08:48 AM

Correct answer should be UNIION Hi, The correct answer should be union, as result set is the result of both the query. Mahesh 01-13-2015 01:19 AM

sql ,plsql where there is will and there is way. bisal 08-28-2014 11:42 AM

Union Union also returns rows that are retrieved by both queries Venkat 07-31-2013 02:11 PM

Write your comments

*

* Email must be in the form someone@domain.com

*

*