This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!
This video covers Set operators such as UNION, UNION ALL, INSERSECT, and EXCEPT. These operators combine the outputs of two common-table expressions into a single output. This provides a feature similar to joins but without use of the FROM clause.
The SQL code is available here: [ Ссылка ]
If you need to setup your own database environment, check out learn-databases! The easy way to get going and follow along with these videos. [ Ссылка ]
This video is part of the textbook Applied Database Management [ Ссылка ]
Here's the entire playlist: [ Ссылка ]
