Series: Subject: Topic:
Question: 104 of 429

SET Operator

What is a SET operator? What are the types what is the difference between SET operators and JOINS?
Asked by: jagadeesh9 | Member Since Feb-2008 | Asked on: Mar 25th, 2008

View all questions by jagadeesh9   View all answers by jagadeesh9

Showing Answers 1 - 4 of 4 Answers

Answered On : Apr 23rd, 2008

View all answers by Archana

In table the data is represented as relation , the operators used to operate this type of data is known as set operater.Some set operators are: 1.union() 2.intersection() 3.minus() etc...

Yes  1 User has rated as useful.
Login to rate this answer.

SET operators are used to combine similar type of data from two or more tables.  The no of columns and their data type must be same in all the queries. The column names from the first query will appear in the result.UNION         - It returns rows of first query + rows of second query minus duplicate rowsUNION ALL - It returns rows from both the queries including duplicate rows.MINUS         - Rows that are unique for the first query will be retrievedINTERSECT  - common rows from both the queries will be retrieved.Join is used to select columns from two or more tables.

Yes  4 Users have rated as useful.
Login to rate this answer.

Answered On : Sep 20th, 2010

View all answers by dajjaal

The UNION operator is used to combine the result-set of two or more SELECT statements.   SQL joins are used to query data from two or more tables, based on a relationship between certain columns in these tables.

Login to rate this answer.

Answered On : Apr 5th, 2012

Union --> All rows/cols from 1st select and 2nd select with no duplicates
Union All -->All rows/cols from 1st Select and 2nd Select with duplicates
Intersect --> Rows common in both select statements
Minus --> The MINUS query returns all rows in the first query that are not returned in the second query.

Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.