The SQL Workshop by Frank Solomon

The SQL Workshop by Frank Solomon

Author:Frank Solomon
Language: eng
Format: epub
Publisher: Packt Publishing
Published: 2020-12-29T00:00:00+00:00

Build a list of all the OrderID values in the Orders table, as follows:USE packt_online_shop;


FROM Orders O;

Add a WHERE clause to the query. Use NOT IN to filter the Orders table with the subquery that we built first. Sort the result set by OrderID:USE packt_online_shop;


FROM Orders O



The output is as follows:

Figure 7.3: Printing the ID that's not common for the order in the OrderItems table

In this exercise, we filtered out the order ID for the order that does not have a corresponding entry in the OrderItems table.


Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Popular ebooks
Serverless ETL and Analytics with AWS Glue by Vishal Pathak Subramanya Vajiraya Noritaka Sekiyama Tomohiro Tanaka Albert Quiroga Ishan Gaur(1054)
The SQL Workshop by Frank Solomon(401)
Graph Data Processing with Cypher by Ravindranatha Anthapu(377)
Open Source Projects - Beyond Code by John Mertic(373)
The AI Product Manager's Handbook by Irene Bratsis(355)
Data Literacy in Practice by Angelika Klidas Kevin Hanegan(354)
Developing Robust Date and Time Oriented Applications in Oracle Cloud by Michal Kvet(350)
Applied Machine Learning and High-Performance Computing on AWS by Mani Khanuja | Farooq Sabir | Shreyas Subramanian | Trenton Potgieter(347)
Graph Data Modeling in Python by Gary Hutson and Matt Jackson(267)
The Essentials of Computer Organization and Architecture, Sixth Edition by Linda Null(240)
Python QuickStart Guide by Oliver Robert;(179)
Let Us Python Solutions - 5th Edition by Kanetkar Yashavant;Kanetkar Aditya; & Aditya Kanetkar(135)
Research and Technical Writing for Science and Engineering by Meikang Qiu & Han Qiu & Yi Zeng(128)
R for Data Analysis in easy steps 2nd Edition by Mike McGrath(89)
IT Essentials Companion Guide v8 by Cisco Networking Academy(84)
Software Requirements Essentials: Core Practices for Successful Business Analysis (for True EPUB) by Karl Wiegers & Candase Hokanson(75)
Python Tools for Scientists by Lee Vaughan(75)
Continuous Integration (CI) and Continuous Delivery (CD) by Henry van Merode(75)
Distributional Reinforcement Learning by Marc G. Bellemare;Will Dabney;Mark Rowland;(73)
GitHub for Dummies by Guthals Sarah;(71)