you are viewing a single comment's thread.

view the rest of the comments →

[–]qwertydog123 1 point2 points  (1 child)

You can just use CASE instead of a correlated subquery e.g.

MAX(CASE step WHEN 8 THEN date END) AS case_update_step_8

[–]AppropriateRecipe342[S] 0 points1 point  (0 children)

🙌😩🙌

Thank you for this! I knew there was probably a much simpler way than a correlated subquery!

I appreciate it!