Purpose
You can search a table using iterative self-join and set operations. Multiple definitions of the nonrecursive form can be used with a single SELECT statement by specifying different queries by name.
You can only use the WITH statement modifier with SELECT statements. The WITH statement modifier cannot be used with other DML statements.