How to Use Inline Queries in SQL - Select From Select
In this episode, we're going to look at inline queries in SQL which allow you to essentially "select" from another "select" statement. This can be very handy when you need to join only a specific subset of data into your query from another table. This performs a similar role to the Common Table Expression (CTE) which we covered in a previous episode, but seems to be supported on more platforms than CTE. Also, inline queries generally have better performance than CTE in complex queries.
Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html
Want my team to do a project for you? Let's get to it!
https://system.billzone.com/smdeproje...
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at http://www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...
#sql #sqlserver #dataengineering
