Recursive Queries Using Common Table Expressions (CTE)

Introduction Common Table Expression(CTE) creates a temporary result set within the defined execution scope. Recursive means repeating itself until condition not satisfied. A CTE can be used to create a recursive query. Details CTE can be used in SELECT, INSERT, UPDATE, DELETE and CREATE VIEW statement.