How to create Derived Tables in SQL Server
Another video brought to you by BeardedDev, bringing you tutorials on Data Engineering, Business Intelligence, T-SQL Programming and Data Analysis.
If you like the video you can support me on Patreon, / beardeddev
In this SQL tutorial I answer the below questions:
What are derived tables?
When should I use a derived table?
I talk you through how to create derived tables and what there typical use cases are, in the examples I also demonstrate common errors you might get or see when working with derived tables.
Finally I show the execution plans of the queries and explain how derived tables are executed inline and what that actually means.
Code Samples - this is not complete but you can copy and paste and change as necessary
SELECT
AVG(Total)
FROM
(
SELECT
CustomerID,
SUM(TotalDue) AS Total
FROM Sales.SalesOrderHeader
GROUP BY CustomerID
) AS D
-- executed inline
SELECT
CustomerID,
SUM(TotalDue) AS Total
FROM Sales.SalesOrderHeader
GROUP BY CustomerID;
SELECT
CustomerID,
SUM(TotalDue) AS Total
FROM
(
SELECT
CustomerID,
TotalDue
FROM Sales.SalesOrderHeader
) AS D
GROUP BY CustomerID;
Watch video How to create Derived Tables in SQL Server online without registration, duration hours minute second in high quality. This video was added by user BeardedDev 10 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,72 once and liked it 13 people.