Member Avatar for lacxs143

can you explain what is a CTE?
thank you !

  • 2 Contributors
  • 1 Reply
  • 66 Views
  • 17 Minutes Discussion Span
  • Latest Post Latest Post by RomelynCastillo
Member Avatar for RomelynCastillo

A common table expression (CTE) is a temporary named result set that can be used within other statements like SELECT, INSERT, UPDATE, and DELETE. It is not stored as an object and its lifetime is limited to the query.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.