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

submitted 2 years ago by megaman1970@beehaw.org to c/programming@beehaw.org

13 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?

you are viewing a single comment's thread
view the rest of the comments

[-] lwhjp@lemmy.sdf.org 2 points 2 years ago

Yes, CTEs are awesome. Especially when you don't force materialization and the optimizer can work its magic.

I've had a lot of fun with window functions as well.

this post was submitted on 12 Jun 2023

15 points (100.0% liked)

Programming

14108 readers

12 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 2 years ago

MODERATORS

alyaza@beehaw.org

Hexorg@beehaw.org

remington@beehaw.org