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