Interview Questions and Answers
Difference between CTE and Derived table
Difference b/w CTE and Derived table:
| CTE | Derived Table |
| A CTE can be referenced multiple times in the same query. So CTE can use in recursive query. | Derived table can’t referenced multiple times. Derived table can’t use in recursive queries. |
| CTE are better structured compare to Derived table. | Derived table’s structure is not good as CTE. |
Post a Comment
0 Comments