bing
Flat 10% & upto 50% off + Free additional Courses. Hurry up!

UNION Operator

 

It is used to combine the two or more results. The each SELECT statement must have same no. of columns, same datatypes and in the same order.

Syntax:

SELECT column_name FROM table1

UNION

SELECT column_name FROM table2;

  • The Union displays unique values by default. To get the duplicate values we use UNION ALL.

SELECT column_name FROM table1

UNION ALL

SELECT column_name FROM table2;

Example:

SELECT City FROM Student_details

UNION

SELECT City FROM College;

"0 Responses on UNION Operator"

Training in Cities

Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.

top

Sales Offer

  • To avail this offer, enroll before 04th December 2016.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer
offer-june

Sign Up or Login to view the Free UNION Operator.