Programming

13368 readers

2 users here now

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.

founded 1 year ago

MODERATORS

[email protected]

What's your favorite construct in SQL? (beehaw.org)

submitted 1 year ago by [email protected] to c/[email protected]

5 comments fedilink hide all child comments

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?

top 5 comments

sorted by: hot top controversial new old

[–] [email protected] 1 points 1 year ago (1 children)

Only thing cooler than CTEs are Recursive CTEs, but I struggle to find use cases where I can sneak one in.

[–] [email protected] 1 points 1 year ago

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.

[–] [email protected] 1 points 1 year ago

https://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL#Common_table_expression

[–] [email protected] 0 points 1 year ago (1 children)

CTEs are so helpful for me. They make complex queries much easier to construct and lets me ‘unit test’ the parts I’m working on.

[–] [email protected] 1 points 1 year ago

Same here, CTEs were a game changer for me when I learned about them