Answered Questions

  • SET Operator

    What is a SET operator? What are the types what is the difference between SET operators and JOINS?

    Aparna

    • 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...

    dajjaal

    • Sep 20th, 2010

    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.