SQL tutorial 68: Union and Union All SQL Set Operator In Oracle Database By RebellionRider

Union and Union all Set operator in SQL/Oracle Database with example also the difference between union and union all. NExt tutorial will cover Intersect and minus set operator. Manish Sharma RebellionRider
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog :bit.ly/union-union-all-set-ope...
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►►►Help Me In Getting A Job◄◄◄
►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company
Thanks
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
/ rebellionrider
/ imthebhardwaj
/ rebellionrider
plus.google.com/+Rebellionrider
/ mannbhardwaj
/ rebellionrider
/ rebellionrider
You can also Email me at
for E-mail address please check About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[@kosta2177]

Good, short, understandable. Thanks.

[@Sallu0123]

simply superb..............

[@hassanaminmarquez]

Excellent explanation!

[@Jsheng007]

Nice video, easy and efficient

[@shahidhussainshah2654]

Great video (y)

[@nagendra5505]

Great man

[@vikasjagdale7763]

Good Video :)-

[@laukiktijore6266]

awesome explaination Manish Thanks :)

[@Rebellionrider]

Glad you liked it

[@bikramthapa2687]

nice video

[@sumanbhujbal7162]

hello....
you are doing a good job
please make videos on oracle performance tuning

[@faisalchowdhury1688]

actually a 200iq explanation!

[@Rebellionrider]

Thank you for your appreciation. It means a lot.

[@yogeshsawant5154]

finally understood why to_char()

[@ironeagle918]

Can Set Operators be used instead of Join?
If no, how do you know when to use each?

[@satishkumasi2326]

Union will sort the output data, where as Union All will not sort (Performance is good).

[@sumansauravsatpathy]

Classic

[@Rebellionrider]

Thank you so much. Your appreciation means a lot to me.

[@maheshKumar-pu5hr]

sie what is the difference btw natural join and union

[@pascalsolutions6158]

In union operation, the participating tables must have the same number of columns and data types which is not the case for natural join

[@kirannikam4695]

Guys very Imp question from Point of interview,
Number column and data type of a column matter when you write such queries.
I got rejected....from one the company... bullshit...

[@amithnambiar9818]

Lol

[@user-up8gc4kc3c]

「目標を指定してお金が必要」、

[@sameerahmad7592]

Hi Manish,
brother kindly give me a help.....:-(
I want to get the output of this table in this pattern
Question
id name gender
1 A M
2 B M
3 C F
4 D M
5 E F
6 G F
7 H M

Answer
id name gender
M
F
M
F
M
F
M
plz give me a reply back , waiting for your reply.....