• 1 Post
  • 1.2K Comments
Joined 2 years ago
cake
Cake day: June 16th, 2023

help-circle






  • marcos@lemmy.worldtomemes@lemmy.worldSheeple
    link
    fedilink
    arrow-up
    1
    ·
    1 day ago

    It’s hard to cause a large gas explosion by carrying a flame. Gas tends to diffuse, so you get small explosions that dissipate the problem before you reach the large concentrations.

    That said, “hard” does not mean “impossible”. History is full of counterexamples. But it is much easier to make trouble by igniting the flame after you are inside.











  • It seems that you need to get better. There are plenty of valid complaints against SQL, but your problems seem to be all due to lack of familiarity.

    No variables, no functions; Oh but you can do a CTE

    Yeah, CTEs are more expressive than variables. And as somebody pointed, every database out there supports functions, you may want to look how they work.

    UNION ALL, UNION ALL, UNION ALL… “There’s got to be a better way, surely…”

    What do you mean by a “better way”? Union all is a perfectly valid operation.

    And then you try put a MAX in a where and it won’t let you because you gotta pull all the maxes out in their own query, make a table, join them in, and use them like a filter…

    Window functions exist.