Home > database >  SQL CASE in GROUP BY
SQL CASE in GROUP BY

Time:06-27

I have a query that is meant to get the count of each reaction on a comment and whether the user is one of the people who made that reaction. However, my case statement returns includesMe:1 for EVERY reaction when the user has made at least one reaction on the comment.

Eg, if the user only reacted to

  • Related