15
What's your favorite construct in SQL? (beehaw.org)
submitted 1 year 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
[-] DarkAngelofMusic@lemmy.world 0 points 1 year ago

CTEs can be useful, particularly in PostgreSQL, where there are writable CTEs, but a lot of the time, I prefer using temp tables over CTEs, as they often perform better for larger datasets. I think one of my favorite constructs is window functions. I've found many uses for them, over the years.

[-] megaman1970@beehaw.org 1 points 1 year ago

There was one time a good while back where I used window functions to perform edge detection in a dataset. I'll see if I can dig up that query later.

this post was submitted on 12 Jun 2023
15 points (100.0% liked)

Programming

13269 readers
11 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
alyaza@beehaw.org
Hexorg@beehaw.org
remington@beehaw.org