The WITH clause comes in two forms:

• Standard CTEs, as shown in the previous section (using the WITH clause)
• A method to run recursions in SQL

The simple form of a CTE was already covered in the previous section. In the next section, the recursive version will be covered.