Tutorial 26 - Union and Union All | PostgreSQL

In this video I explained Union and Union All operators.
UNION is used to combine the results of 2 or more SELECT statements. It removes any duplicate rows between the different SELECT statements. These select statements needs to have the same number of columns and similar data types for this join to be successful.
If you do not want to remove duplicates, then use UNION ALL operator.
*Books I recommend*
1. Grit: The Power of Passion and Perseverance amzn.to/3EZKSgb
2. Think and Grow Rich!: The Original Version, Restored and Revised: amzn.to/3Q2K68s
3. The Book on Rental Property Investing: How to Create Wealth With Intelligent Buy and Hold Real Estate Investing: amzn.to/3LLpXRy
4. How to Invest in Real Estate: The Ultimate Beginner's Guide to Getting Started: amzn.to/48RbuOb
5. Introducing Python: Modern Computing in Simple Packages amzn.to/3Q4driR
6. Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter 3rd Edition: amzn.to/3rGF73G
Below is the link to the PostgreSQL Playlist
• Tutorial 1 - What is D...
Link to the INNER join video:
• Tutorial 22 - Inner Jo...
Link to the LEFT join video: • Tutorial 23 - Left Joi...
Link to the RIGHT join video: • Tutorial 24 - Right Jo...
Link to the FULL OUTER join video: • Tutorial 25 - Full Out...
Please don’t forget to LIKE, SHARE, COMMENT and SUBSCRIBE to our channel for more AWESOME videos.
DISCLAIMER: This video and description has affiliate links. This means when you buy through one of these links, we will receive a small commission and this is at no cost to you. This will help support us to continue making awesome and valuable contents for you.

[@bayoadegun]

Great explanation of UNION and UNION ALL, my go to playlist for comprehensive and detailed videos. Thanks

[@tuplespectra]

You are welcome!

[@dishanth2]

thank you so much

[@tuplespectra]

You're welcome!

[@mabawonkutosin783]

Thank you for the video.

[@tuplespectra]

You're welcome

[@johnsonrouna]

Thank you for this

[@tuplespectra]

Thank you!

[@ceving865]

Please stop saying OK.

[@mhrsolanki2020]

OK