Subquery MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Subquery
  4. Creating a Derived Table
7>  SELECT *  FROM ( SELECT 'Fred' As FirstName, 'Flintstone' As LastName)
8> AS CartoonCharacter
9>
FirstName LastName
--------- ----------
Fred      Flintstone