Select from following answers:
Show Correct Answer
- A derived table cannot be re-used within a query. Consider using a CTE or view in that instance.
- A derived table is not a physical object within the database, it only exists at execution time.
- Derived tables are not exclusive to SQL Server, other RDBMS systems support them, MySQL, Oracle, etc.
- Can be used to help simply code writing, for example GROUP BY CASE WHEN statements as above.
- All Above
Asked In: Many Interviews |