Which statement is/are correct about Derived Table?

 Posted by vishalneeraj-24503 on 2/3/2015 | Category: Sql Server Interview questions | Views: 1111 | Points: 40
Select from following answers:
  1. A derived table cannot be re-used within a query. Consider using a CTE or view in that instance.
  2. A derived table is not a physical object within the database, it only exists at execution time.
  3. Derived tables are not exclusive to SQL Server, other RDBMS systems support them, MySQL, Oracle, etc.
  4. Can be used to help simply code writing, for example GROUP BY CASE WHEN statements as above.
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response