Union and union all in sql server Part 17

In this video we will learn about the
1. Purpose of UNION and UNION ALL
2. Difference between UNION and UNION ALL
3. Difference between JOIN and UNION
Text version of the video
csharp-video-tutorials.blogspo...
Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our RUclips channel. Hope you can help.
/ @aarvikitchen5572
Slides
csharp-video-tutorials.blogspo...
All SQL Server Text Articles
csharp-video-tutorials.blogspo...
All SQL Server Slides
csharp-video-tutorials.blogspo...
All Dot Net and SQL Server Tutorials in English
ruclips.net/user/kudvenka...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic

[@Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[@pravingaddam8541]

Thanks for great video explanation. Can u please help answer of question---
Question--> I am having 2 table emp, employee table. emp contain eid, salary and employee contain eid, salary and ename column now here I want to represent Only all columns of employee table using Union clause of this 2 tables

[@etherealvox2010]

Whenerver I look up a programming topic on youtube and the search returns among others a video of yours I know I'm gonna master that topic . Thank you very much for your videos . Professionally made , clear , concise . Keep up the good work !

[@KingofKingziam]

Best explanation for UNIONS right here. I understood it the first time I watched it. I will definitely recommend this videos to all my SQL learning buddies. Thanks :) awesome!!!!

[@krzysztofs8535]

I'm going to see all videos from this SQL course. Great , really great job! Greetings from POLAND

[@anjujain4149]

You are simply the best. I took SQl course etc but didn't learn much ..tks!!

[@armandohernandez5574]

Im watching this in 2017.. Thankyou so much for posting this. really helps a lot!

[@TrainITHard]

Thanks for the course! Nice and easy-understandable explanations! Continue watching.

[@BoYcLuE]

Best...SQL..Tutorials...Ever constructed. Thank you so much.

[@KhanhLe-ci3fc]

You are a great teacher! Thank you so much for your time.

[@charbelhajjar10]

select * from Kudvenkat :) Thank you

[@univuniveral9713]

select * from these lessons ill help me for my next interviews union I do not have to read huge books

[@IbrahimEl-khalilMAdams]

select * from Kudvenkat where youtube.channel = N"SQL server" or youtube.channel = N"C#"

[@TheBitles]

Thanks for this video, it's very easy to understand even for beginners like me.

[@trunghaiha7379]

I've been searching for my problem on Google for so long untill found out your videos. Thank you so much for this super clear explanation.

[@stubbymr]

You are a blessing :) A great teacher !

[@Trzbne]

Wonderful tutorial again! I am looking forward to see Stored procedures!!!

[@onemanenclave]

Superb meticulous explanation! Thank you! It would've taken me an extra hour to understand this without your video.

[@raoulisdimitris3396]

Great tutorials , respect to the Tutor!

[@sophiama6304]

very good explanation of the difference between union and join: one combines rows, one combines columns.

[@64090sayan]

Venkat sir....GOD BLESS YOU...:)....UR VIDEOS WERE OF IMMENSE HELP TO ME....LONG LIVE VENKAT SIR....

[@lavandeepgarg8824]

Great Work Mr. Venkat .... You are simply awesome ..

[@reemasharma5833]

Teacher is "who make complex thing simple" like you sir!!!!!!!!!!!! :)

[@devikar8224]

One of the best explained tutorials on SQL Server. Your videos has helped me a great in learning SQL Server.

[@Csharp-video-tutorialsBlogspot]

Hello Devi - Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.

[@ancarada2916]

Thank you for the videos!!! You are so talented and smart. :)

[@manishavishwakarma5363]

Very nice explanation, you covered all the points regarding union, very nice.

[@sreenusreenu3099]

Yeah atlast i found a wonderful teacher to learn

[@Nicetrycutiepie]

Thanks for letting us know about execution plan and short cut for it ctrl L

[@clivesibiya]

Great teacher. Thank you

[@vishnu_bhatt]

Detailed Explanation.Thank you sir.

[@huiqingxu5286]

You are an amazing teacher!

[@justinli19901027]

as helpful as ever! thank you !

[@shamsnoman1402]

great videos. easy to understand. thanks for sharing

[@adil47ful]

Superbb..Explanation! wenever i need an explanation for a IT topic, first i checked wd KUDVENKAT..because his teaching style is unique and simple! ALLAH bless you!

[@rira4956]

Great Videos !! I am a great fan of your videos.

[@Csharp-video-tutorialsBlogspot]

+ri ra Thanks a million for taking time to give feedback. I am glad you found the videos useful.
Free Dot Net & SQL Server videos for web developers
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs for offline viewing, you can order them using the link below
www.pragimtech.com/Order.aspx
Code Samples, Text Version of the videos & PPTS on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use our channel
ruclips.net/video/y780MwhY70s/видео.html
Want to receive email alerts, when new videos are uploaded, please subscribe to our channel using the link below
ruclips.net/user/kudvenkat
Please click the THUMBS UP button below the video, if you think you liked them
Thank you for sharing these links with your friends
Best
Venkat

[@dheerajkeerthi]

nice videos mr.venkat am learning lot of things.. hope u cover much topics.....Tq

[@NicholasNemirsky]

Very Helpful! Thank You!!

[@pramodmaurya6610]

Thanks for your knowledge sharing.. thanks a lot sir

[@piyasidey2117]

You are really great Sir...Thank You very Much...

[@balakrishnamodugula8116]

No one can explain Better than you .............Good!!!!!!

[@72sh]

If you dont mind, ur statement is wrong actually and will give wrong impression to the ppl who sees it.
It should be 'No one can explain better than you'

[@kumarraja1441]

Thanks man. Really it was helpful in my project that too deadline at last day of project release .. Kudos 👏🏻. That’s y one like and one subscribe for u..okay. Bell 🔔 kuda pressed 🤪😀

[@hamedhomaee6410]

Actually, I give like to your videos before watching them, that is how Amazing you are.

[@kiransingh8239]

wonderfull explanation , thanks a lot for putting these videos

[@PuniKM]

You are saving lives!

[@mrafaqatpk]

Great Great Great work !!

[@ventjemazzel8822]

Clear explanation; thanks!

[@shedhenriqueFNS]

Thank's for share, nice work.

[@vivek77]

thanks for posting these videos, can you please add in description create table queries also which is being used in the video. It will make it easier to follow and practice.

[@kirannadukula5247]

Thank you, Sir!!!!!!!!!!

[@donwest1806]

Thank you sir, for this video. 🙏🙏

[@brushupkid3853]

May god bless you sir !!!

[@raghavendrareddy5275]

thank u sir, it is very helpful.

[@Harish0328]

Very useful videos venkat

[@abotmo7301]

easy and understandable , AWESOME , THANK YOU SO

[@edwardjacob4098]

Thanks for the Tutorial.

[@vishaljhaveri7565]

Nice video. Thank you, Sir.

[@lemonvariable72]

Great vid

[@aliazad1118]

As usual perfect

[@sijimathew9982]

Thank you sir

[@AhmadElkhouly]

Thank you! ❤

[@AlpPamuk]

Nice explanation!

[@piyasidey2117]

Like the way You speak..

[@javierflores2543]

Thank you sir!!!!!

[@gamareshkumar6908]

Thanks for the nice explanation

[@dhanrajdhan266]

Thank you so much

[@bizzar31]

you are awesome sir

[@nino9044]

Thank you , very good online lessons
found small error
has to be in writing blue screen - UNION performs distinct sort to remove duplicates, which makes it less SLOWER than UNION ALL ( instead od faster)

[@nehamaggu3719]

hello kudvenkat...ur videos are so clear for developing basic understng.if possible please provide trainning on database testing videos ..thanks you

[@prabhatkumar1162]

awesome sir. very helpful.

[@sureshrajput5794]

Venket sir will u please teach me what is the use of INTERSECT and MINUS operator ??

[@rkb8379]

you are correct mouradbarakat123 but with your query in the output will look like this:
1. Murad Mumbai
2. Pune Singh
Logically it works fine but it doesn't make sense as the end result hence following the right order, datatype of the columns really helps to sort it in a meaningful way
I hope this clarifies and Venkat's video also explains the same...
Please do correct if required...
Cheers !

[@mattlesort3394]

great work

[@mouradbarakat123]

Thanks for the video. It's the best on the web for SQL Server.
The "order of the columns" should be irrelevant, in fact even columns names doesn't have to match, only number of columns and data type are what matter! The individual data sets may come from completely different tables or queries. For example:
select Name, City from tblEmployee
union
select City, Name from tblEmployee1
is perfectly fine, even the "order of the columns" is reversed! but from the SQL Server it's irrelevant!

[@MaheshTiwari-hq7lr]

try out, this would not give you the exact result , For Name you will get city and for City you will get name if you font follow the order.

[@nitugupta9933]

Excellent video sir

[@rishabhtripathi6828]

your teaching is awesome. but what I like the most is "HELLOO".

[@TheSantoshmenon]

Thanks for sharing

[@nehamaggu3719]

hello kudvenkat. nice videos if possible please provide trainning on database testing videos ..thanks you

[@stutitehri993]

nice tutorials

[@danny63843]

thank you

[@piyako3586]

Watching in 2024🎉🎉🎉Best tutorial ever

[@testuse6868]

Can we get the database that you are using throughout this course? It will be really helpful.

[@divyasingh5612]

Awesome sir

[@aimeeschoeman3914]

love!!!

[@udayboddupelly1889]

well explanation

[@gjhxfy754ghh]

Can't we use UNION along with CTE and SELECT INTO to extract unique rows from a table which contains duplicate rows.
With exCTE as
(
select * from dupeRows
UNION
select * from dupeRows
)
select * into tmptbl from exCTE
This works, but not sure whether it is resource intensive.

[@ramantharji9881]

Thank you so much for ur videos
Could you please do a Playlist videos in SSRS, SSIS, SSAS, POWER BI.

[@SaMpl3_T3xt]

nice and informative

[@kbkonatham1701]

what if when one of my select statements have duplicates records

[@semiileka9571]

where can i get the script for this database

[@vattikiti]

Hi Venkat, Can you please share sql interview questions ?

[@pritiiBisht]

Bestest:))

[@pvksmaheeth8816]

sweet voice

[@SHIVAKUMAR-mp7ux]

👍

[@neilsukalikar4257]

Please start adding tytorials for JQuery as well ..

[@SuperGojeto]

Actually OrderBy is needed more for UNION ALL otherwise if u execute the same query for UNION on those 3 tables without OrderBy it automatically sorts the result based on names. I think that is what you meant by Distinct Sorting in Union Query.

[@MaheshTiwari-hq7lr]

yes correct

[@berzaipeter2736]

Hello
As I notice, the number of rows in the the tables should be the same too for the UNION to work, otherwise it doesn't remove the duplicate, only sorts the rows, leave the duplicate in place. Why didn't you tell us about THIS?
Anyways thanks as always for the videos.

[@IbrahimEl-khalilMAdams]

I think that Kudvenkat should be awarded by Microsoft.

[@jackkaran3405]

What is there are more than two tables

[@ramprakashchalla8978]

hi how to union tables dynamically

[@adilxaif4551]

what if the number of rows in the table are difference does it works?

[@naveenkumarrallabandi9724]

yes it will work that's not a problem.

[@calltocreator8851]

How to put Union All query Result into a new table or temporary table? Please help.

[@MDARIF-yo3tq]

i am using union but it doesn't remove duplicate value

[@simrankaur4269]

Same in my case
Did you get the answer why it's not removing duplicate value??

[@shamskabra]

hey guys ! any one having the same problem , my UNION is not omitting the duplicate

[@riteshpardeshi9866]

The video was not that user-friendly but you'll concept will be clear.