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?

  • Leo Uino@lemmy.sdf.org
    link
    fedilink
    arrow-up
    2
    ·
    1 year 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.