Answer to Question #76507 in Databases | SQL | Oracle | MS Access for J

Question #76507
What is S an alias of in the query below?
select orderid, salespersonname
from
(select salespersonid, salespersonname, SalespersonTelephone
from Salesperson_T where SalesTerritoryID = 1) S
join Order_T O
on O.SalespersonID = S.SalespersonID


An Outer Join


A Derived Table


A Union


A Join
1
Expert's answer
2018-04-28T12:06:08-0400
Derived Table

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
APPROVED BY CLIENTS