Derived Table | Virtual Table | DT | Derived Table vs SubQuery | Table Value Constructor | Nested DT

Derived Table | DT | Virtual Table | Derived Table vs SubQuery | Table Value Constructor | Nested DT Agenda: ------------ Q01. What is Derived Table and which version of SQL supports the Derived Table? Q02. What is the difference between Derived Table and SubQuery? Q03. Is Nested Derived Table and Recursive Derived Table allowed in SQL? Q04. Can you use the Derived Table without the alias name? Q05. Can you JOIN a table with the Derived Table? Q06. Can you use a Derived Table in the WHERE clause? Q07. Are duplicate column names allowed in the Derived Table? Q08. Is an anonymous column name or column with no name is allowed in the Derived Table? Q09. Can you use filter the record by applying the ORDER BY clause in the Derived Table? Q10. Can you DELETE the records from the Derived Table? Does it also affect the actual underlying base table? Q11. Can you UPDATE the records from the Derived Table? Does it also affect the actual underlying base table? Q12. Can you INS