Select from following answers:- 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
Above all statements are correct about Derived Table.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator