Tata Consultancy Services
Part of Tata Group
Engaged Employer
Tata Consultancy Services Interview Question
Difference between CTE and Temp Table
Interview Answer
Anonymous
Jun 25, 2024
The CTE has an execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. You can't reuse the CTE, like you can with temp tables.