Programming

3347 readers

1 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]

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

[–] TitanLaGrange 1 points 1 year ago

I find the MERGE statement to be extremely useful.

Window functions I really want to like, but I don't have enough uses for them to learn them well enough to feel really comfortable with them.