Common table expressions (CTE) page 3
The query we have used in SQL Server -
Relation "cte" does not exist.
This error means that we cannot delete rows from common table expressions (CTE), but only from base tables.
To do it, let's try the following algorithm:
Let's use the table from cited example for writing the query:
Here the query is
When we run the query
the desired result will be obtained: