Joe Kelly-376311 (10/22/2013)
What am I missing here ??
Will "delete from ABC_CTE where id = 1;" not just delete the one record where id = 1 ??
Yes, it will. You are not missing anything. Four rows are inserted, one is deleted - three remain, which is the correct answer.
The point of the question is that you cannot just delete directly from a table, but also through a CTE - exactly the same way as you can delete rows through a view (and with the same rules and restrictions).