A developer defines a CTE before a SELECT and expects it to remain available to unrelated later statements. What should be clarified?

Published
  1. A CTE is scoped to the associated statement rather than being a persistent table
  2. CTE naming determines backup retention
  3. Every CTE automatically creates a permanent database table
  4. A CTE grants all users access to the source

Comments — 0