Off the top of my head, probably recursive CTE.
Recursive processes in POSH, .Net or VBS - say to explore a directory structure - clear as a bell. But for some reason recursive SQL doesn't sit terribly well with me, I can do it, but if asked to pen an example in an interview I'd leave that one 'till last
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.