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

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"

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

Sales Offer

  • To avail this offer, enroll before 24th July 2017.
  • 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.