techmixing.com
Derived Table In Sql Server - Technology with Vivek Johari
This article Derived table in SQL Server explains the derived tables which are created on the fly with the help of the Select statement.