The WITH prefix to the SELECT statements affords you the opportunity to define common table expressions. These can be used like temporary views within your query. This chapter describes how to use them.
About common table expressions
Typical applications of common table expressions
Recursive common table expressions
Parts explosion problems
Datatype declarations in recursive common table expressions
Least distance problem
Using multiple recursive common table expressions