u/thequerylab

1,391 post karma · 47 comment karma · joined Mar 2026 · moderator

  1. 91points

    Before your next SQL interview, keep this post handy - SQL Execution Order (Part 5) (self.learnSQL)

    10 comments

  2. 6points

    Before your next SQL interview, keep this post handy - SQL Execution Order (Part 5) [Discussion]

    0 comments · source

  3. 112points

    Before your next SQL interview, keep this post handy - CTEs vs Subqueries (Part 4) (self.learnSQL)

    13 comments

  4. 0points

    Before your next SQL interview, keep this post handy - CTEs vs Subqueries (Part 4) [Discussion]

    1 comments · source

  5. 107points

    Before your next SQL interview, keep this post handy - WHERE, GROUP BY and HAVING (Part 3) (self.learnSQL)

    8 comments

  6. 1points

    Before your next SQL interview, keep this post handy - WHERE, GROUP BY and HAVING (Part 3)

    0 comments · source

  7. 72points

    Before your next SQL interview, keep this post handy - SQL JOINs (Part 2) (self.learnSQL)

    4 comments

  8. 1points

    Before your next SQL interview, keep this post handy - SQL JOINs (Part 2) [Discussion]

    1 comments · source

  9. 118points

    Before your next SQL interview, keep this post handy - SQL Window Functions (Part 1) (self.learnSQL)

    10 comments

  10. 0points

    Before your next SQL interview, keep this post handy - SQL Window Functions (Part 1) [Discussion]

    1 comments · source

  11. 149points

    If you have an SQL interview soon, don’t ignore these small things!!!! (Part 10) (self.learnSQL)

    11 comments

  12. 1points

    If you have an SQL interview soon, don’t ignore these small things!!!! (Part 10)

    0 comments · source

  13. 25points

    If you have SQL interviews, do not ignore these small things! (Part 9) (self.learnSQL)

    24 comments

  14. 3points

    If you have SQL interviews, do not ignore these small things! (Part 9) [Discussion]

    1 comments · source

  15. 1points

    If you have SQL interviews, do not ignore these small things! (Part 9)

    0 comments · source

  16. 12points

    Do you have any success stories on optimizing Snowflake cost. Any hidden tricks or anything worth highlighting? (self.snowflake)

    27 comments

  17. 7points

    Anyone here managed to significantly cut their Snowflake bill? What actually worked? (self.SQL) [Snowflake]

    1 comments

  18. 1points

    Do you have any success stories on optimizing Snowflake cost. Any hidden tricks or anything worth highlighting (self.dataengineering) [Discussion]

    1 comments

  19. 222points

    If you have SQL interviews, do not ignore these small things! (Part 8) (self.learnSQL)

    13 comments

  20. 7points

    If you have SQL interviews, do not ignore these small things! (Part 8) [Discussion]

    0 comments · source

  21. 1points

    If you have SQL interviews, do not ignore these small things! (Part 8)

    0 comments · source

  22. 185points

    If you have SQL interviews do not ignore these small things! (Part 7) (self.learnSQL)

    8 comments

  23. 1points

    If you have SQL interviews do not ignore these small things! (Part 7)

    0 comments · source

  24. 144points

    If you have an SQL interview soon, don’t ignore these small things!!! (Part 6) (self.learnSQL)

    18 comments

  25. 4points

    If you have an SQL interview soon, don’t ignore these small things!!! (Part 6) [PostgreSQL]

    3 comments · source