☕ If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE --------------------------------- ⏱ TIMESTAMPS ⏱ --------------------------------- 00:00 JOINS vs UNION 01:01 Example of UNION 03:16 UNION vs UNION ALL 03:30 Example of UNION and UNION ALL Enjoy :)
this is just an ingenious explanation, thanks a lot for this visualization! I'm watching your lessons a lot and finally I see a huge progress in SQL. thank you!!!
Namastey Baraa sir, In 7:03 mins, you mentioned in Union the first query controls the naming in result. I tried to change my 2nd Select statement with following col sequence as emp_country, first_name, last_name. The result of 2nd table was changed, in the column of 'first_name' , country name were listed. Is this behaviour is expected in current MySQL version? first_name last_name country Maria Cramer Germany John Steel USA Georg Pipps UK Martin Müller Germany Peter Franken USA USA John Steel France Ann Labrune Brazil Marie Bertrand UK Georg Afonso UK Marie Steel
Sir, your tutorials are such helpful which can't be expressed in words. You make short videos but explain lots in that. I watched joins concepts from Coursera but I didn't learn anything from there despite of spending a complete week. I thank you a lot for the effort and ask GOD to reward you for that. I request if you can make Power BI tutorials the same way, it will be absolutely helpful for us as beginners.
Hi Muhammad, thank you so much for taking your time to write me this amazing feedback, i am really happy you liked it. Thanks for your wishes! Thank you again and PowerBI is in my roadmap. :)
☕ If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
---------------------------------
⏱ TIMESTAMPS ⏱
---------------------------------
00:00 JOINS vs UNION
01:01 Example of UNION
03:16 UNION vs UNION ALL
03:30 Example of UNION and UNION ALL
Enjoy :)
this is just an ingenious explanation, thanks a lot for this visualization! I'm watching your lessons a lot and finally I see a huge progress in SQL. thank you!!!
Good explanation , thank you very much sir
Awesome 🎉
Namastey Baraa sir,
In 7:03 mins, you mentioned in Union the first query controls the naming in result. I tried to change my 2nd Select statement with following col sequence as emp_country, first_name, last_name. The result of 2nd table was changed, in the column of 'first_name' , country name were listed.
Is this behaviour is expected in current MySQL version?
first_name last_name country
Maria Cramer Germany
John Steel USA
Georg Pipps UK
Martin Müller Germany
Peter Franken USA
USA John Steel
France Ann Labrune
Brazil Marie Bertrand
UK Georg Afonso
UK Marie Steel
Sir, your tutorials are such helpful which can't be expressed in words. You make short videos but explain lots in that. I watched joins concepts from Coursera but I didn't learn anything from there despite of spending a complete week. I thank you a lot for the effort and ask GOD to reward you for that.
I request if you can make Power BI tutorials the same way, it will be absolutely helpful for us as beginners.
Hi Muhammad, thank you so much for taking your time to write me this amazing feedback, i am really happy you liked it. Thanks for your wishes! Thank you again and PowerBI is in my roadmap. :)