Creating a Derived Table : Inline view « Subquery « SQL Server / T-SQL Tutorial






7> SELECT * FROM (SELECT 'Fred' As FirstName, 'Flintstone' As LastName)
8> AS CartoonCharacter
9>
FirstName LastName
--------- ----------
Fred      Flintstone








8.3.Inline view
8.3.1.Creating a Derived Table
8.3.2.Subqueries and Derived Tables
8.3.3.SELECT FROM (query that returns a regular result set) AS JOIN
8.3.4.A query that required a derived table.
8.3.5.In-Line Views (Derived Tables)
8.3.6.A query that uses a correlated subquery in its SELECT clause to retrieve the most recent Billing for each Banker
8.3.7.Queries in the FROM Clause
8.3.8.Select from nested select statements
8.3.9.Join with (inline)Table Expressions
8.3.10.Finding First Employee Using a Derived Table