Discussion Board

UNION, UNION ALL, INTERSECT, MINUS UNION operator eliminates duplicate selected rows and returns only distinct rows that appear in either result. UNION ALL operator returns all rows and does not eliminate duplicate selected rows. INTERSECT operator returns only those rows returned by both queries. DISTINCT statement is used to return only distinct (different) values. MINUS operator returns only unique rows returned by the first query but not by the second. Prajakta Pandit 02-15-2017 06:03 AM

oracle this is wrong answer the correct answer is minus sravani 02-12-2015 11:32 PM

wrong answer 17 MINUS GP 12-3-2014 03:06 PM

Wrong option Answer should be either MINUS or NOT IN Deepika S Verma 11-12-2014 04:57 AM

Wrong Options Minus is the correct answer. Using Intersect query returns similar records from both queries Rohan Patil 11-5-2014 09:47 PM

in my opinion wrong answer:->minus is correct. minus is correct answer vartika jain 05-21-2014 05:12 AM

in my opinion -> wrong answer MINUS is correct answer oracleBoss 08-8-2013 05:56 AM

online oracle pl.sql question 26 I think this is wrong MINUS returns records that exist in one query and not in the other, intersect returns rows that exist in both queries sally 07-27-2013 07:54 PM

Write your comments

*

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

*

*