SQL Server Queries Part 12 - Correlated Subqueries
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
https://www.wiseowl.co.uk - A correlated subquery is a subquery which depends on an outer query for its values. If that doesn't make much sense, this video attempts to explain exactly what that means. You'll see how to build simple correlated subqueries, including why it's necessary to use table aliases, along with an explanation of what happens when you execute the query.
You can see a written explanation of correlated subqueries here:
https://www.wiseowl.co.uk/blog/s339/correlated-subqueries.htm
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Видео SQL Server Queries Part 12 - Correlated Subqueries канала WiseOwlTutorials
By Andrew Gould
https://www.wiseowl.co.uk - A correlated subquery is a subquery which depends on an outer query for its values. If that doesn't make much sense, this video attempts to explain exactly what that means. You'll see how to build simple correlated subqueries, including why it's necessary to use table aliases, along with an explanation of what happens when you execute the query.
You can see a written explanation of correlated subqueries here:
https://www.wiseowl.co.uk/blog/s339/correlated-subqueries.htm
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Видео SQL Server Queries Part 12 - Correlated Subqueries канала WiseOwlTutorials
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
SQL Server Programming Part 13 - Dynamic SQLUnderstanding Correlated Queries in SQLCorrelated subquery in sql Part 60SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries TutorialSQL Server Queries Part 6 - JOINS (Inner and Outer Joins)SQL Server Queries Part 11 - SubqueriesSQL Correlated SubqueriesWhat are Subquery and Co-related Queries in SQL Server ? | SQL Server Interview Questions & AnswersSQL Server Queries Part 10 - GROUP BY and HAVINGSQL Server Programming Part 17 - The Pivot OperatorSQL Server Programming Part 1 - Stored Procedure BasicsSQL Server Programming Part 5 - IF StatementsCorrelated Sub Queries QuicklyAdvanced SQL Tutorial | SubqueriesSQL Server Programming Part 15 - DML TriggersSubquery In SQL | SQL Subquery Tutorial With Examples | SQL Tutorial For Beginners | SimplilearnWe Learn SQL #13 | Intro to correlated subqueries in SQLSQL Server Programming Part 11 - Common Table Expressions (CTEs)SSRS 2016 Part 1 - Creating and Deploying Your First Report