Recursion in SQL

Recursion if you've never heard the term is loosely defined as when a programming function calls itself. Conceptually recursion can be difficult to grasp, at least according to my classmates back when we were learning it in college. In most programmi...