WITH clause
Common Table Expressions or CTEs act like temporary views that exist only for the duration of a single SQL statement. There are two kinds of common table expressions: "ordinary" and "recursive".
from Pocket https://ift.tt/1jEz2KS
via IFTTT