2
What's your favorite construct in SQL?
(beehaw.org)
Only thing cooler than CTEs are Recursive CTEs, but I struggle to find use cases where I can sneak one in.
I believe recursive CTEs are pretty cool for tree traversal. Anytime you've got a table with a foreign key on its own primary key they might come in handy.
All things programming and coding related. Subcommunity of Technology.
This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.