What is a derived table? When is it used? Can you describe any situations where you would have to use it over a subquery in the WHERE clause?
What will be an ideal response?
A derived table can be created by placing a subquery within the FROM clause. The derived table is simply a temporary table in memory which can be accessed just like a table or view. Sometimes, these are referred to as inline views. A derived table is useful for situations where you need to create aggregate values (such as a sum) and then use these in another query. A derived table would be used instead of a subquery in cases where you need to display results from multiple tables. If the results need to come from a subselect, this is not possible, so we would have to use a derived table.
You might also like to view...
The U.S. Treasury has issued 10-year zero coupon bonds with a face value of $1,000. Assume that coupon payments are normally semiannual. What will be the current market price of these bonds if the opportunity cost for similar investments in the market is 6.75 percent?
A) $684 B) $860 C) $515 D) $604
Generally speaking, which of the following statements is true concerning product attributes?
A) Tangible product attributes are more important than intangible ones. B) Intangible product attributes are more important than tangible ones. C) Both tangible and intangible product attributes are important. D) Neither tangible nor intangible product attributes are important. E) A product has more attributes than tangible and intangible ones.