StateSQLboy
MIS
What in the heck is a derived table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question
- Thread starter StateSQLboy
- Start date
- Status
swampBoogie
Programmer
A select statement in the from clause is called a derived table:
Code:
select 1 from
[COLOR=blue]
(select 'This is a derived table',c from t) dt
[/color]- Status
Similar threads