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.
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
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 !
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!!!!
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'
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!
+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
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 🤪😀
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 !
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!
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.
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)
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.
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.
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.
select * from Countries UNION select * from States All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
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.
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
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 !
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!!!!
You are simply the best. I took SQl course etc but didn't learn much ..tks!!
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.
Im watching this in 2017.. Thankyou so much for posting this. really helps a lot!
Thanks for the course! Nice and easy-understandable explanations! Continue watching.
One of the best explained tutorials on SQL Server. Your videos has helped me a great in learning SQL Server.
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.
I'm going to see all videos from this SQL course. Great , really great job! Greetings from POLAND
No one can explain Better than you .............Good!!!!!!
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'
Superb meticulous explanation! Thank you! It would've taken me an extra hour to understand this without your video.
Thanks for this video, it's very easy to understand even for beginners like me.
Teacher is "who make complex thing simple" like you sir!!!!!!!!!!!! :)
Best...SQL..Tutorials...Ever constructed. Thank you so much.
Actually, I give like to your videos before watching them, that is how Amazing you are.
You are a great teacher! Thank you so much for your time.
You are a blessing :) A great teacher !
select * from Kudvenkat :) Thank you
select * from these lessons ill help me for my next interviews union I do not have to read huge books
select * from Kudvenkat where youtube.channel = N"SQL server" or youtube.channel = N"C#"
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!
very good explanation of the difference between union and join: one combines rows, one combines columns.
Yeah atlast i found a wonderful teacher to learn
Bestest:))
Venkat sir....GOD BLESS YOU...:)....UR VIDEOS WERE OF IMMENSE HELP TO ME....LONG LIVE VENKAT SIR....
your teaching is awesome. but what I like the most is "HELLOO".
Great Videos !! I am a great fan of your videos.
+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
Very nice explanation, you covered all the points regarding union, very nice.
Watching in 2024🎉🎉🎉Best tutorial ever
Great Work Mr. Venkat .... You are simply awesome ..
Wonderful tutorial again! I am looking forward to see Stored procedures!!!
great videos. easy to understand. thanks for sharing
wonderfull explanation , thanks a lot for putting these videos
You are saving lives!
Great Great Great work !!
nice videos mr.venkat am learning lot of things.. hope u cover much topics.....Tq
Thank you sir, for this video. 🙏🙏
Very useful videos venkat
You are an amazing teacher!
May god bless you sir !!!
You are really great Sir...Thank You very Much...
Great tutorials , respect to the Tutor!
easy and understandable , AWESOME , THANK YOU SO
Thanks for your knowledge sharing.. thanks a lot sir
Nice video. Thank you, Sir.
Great teacher. Thank you
Thanks for the Tutorial.
Thanks for the nice explanation
Clear explanation; thanks!
Thank you for the videos!!! You are so talented and smart. :)
Excellent video sir
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 🤪😀
Very Helpful! Thank You!!
Detailed Explanation.Thank you sir.
Thank's for share, nice work.
Thanks for letting us know about execution plan and short cut for it ctrl L
As usual perfect
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 !
Nice explanation!
Thank you! ❤
thank u sir, it is very helpful.
nice and informative
Awesome sir
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!
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.
Like the way You speak..
as helpful as ever! thank you !
Thanks for sharing
hello kudvenkat...ur videos are so clear for developing basic understng.if possible please provide trainning on database testing videos ..thanks you
awesome sir. very helpful.
you are awesome sir
great work
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.
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)
Great vid
well explanation
Thank you sir!!!!!
Thank you, Sir!!!!!!!!!!
nice tutorials
hello kudvenkat. nice videos if possible please provide trainning on database testing videos ..thanks you
Thank you so much for ur videos
Could you please do a Playlist videos in SSRS, SSIS, SSAS, POWER BI.
Thank you so much
Thank you sir
sweet voice
love!!!
thank you
Can we get the database that you are using throughout this course? It will be really helpful.
Venket sir will u please teach me what is the use of INTERSECT and MINUS operator ??
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.
I think that Kudvenkat should be awarded by Microsoft.
👍
Please start adding tytorials for JQuery as well ..
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.
Hi Venkat, Can you please share sql interview questions ?
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.
yes correct
How to put Union All query Result into a new table or temporary table? Please help.
The video was not that user-friendly but you'll concept will be clear.
what if the number of rows in the table are difference does it works?
yes it will work that's not a problem.
what if when one of my select statements have duplicates records
What is there are more than two tables
select * from Countries
UNION
select * from States
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
where can i get the script for this database
hi how to union tables dynamically
i am using union but it doesn't remove duplicate value
Same in my case
Did you get the answer why it's not removing duplicate value??