Mega Code Archive

 

Categories / MSSQL Tutorial / Subquery

 

Creating a Derived Table

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