Skip Navigation
Programming @beehaw.org megaman1970 @beehaw.org

What's your favorite construct in SQL?

For me, it's CTE's. I find it amazing to complete a calculation with clear intermediate steps, and goes a long way towards convincing people to use SQL rather than Excel to perform calculations on large tables of data.

What construct do you like using on a daily basis?

13

You're viewing a single thread.

13 comments

  • 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.

13 comments