0
  • CTE is represented as Common Table Expression. It specifies the temporary named result set.
  • This result set is obtained by executing simple queries.
  • CTE can be referred to in SELECT, INSERT, UPDATE, DELETE and MERGE statements. Moreover, CTE can also be used in VIEW statements.
  • There are two types of CTE – recursive and non-recursive.
BrindhaPrathaban Answered question April 19, 2023