Topics

groupby multiple things

the SQL query I want to convert ends with:

GROUP BY 
  u.user_id,
  e.ExerciseID;

GROUP BY 
  u.user_id,
  e.ExerciseID;

I see no where in the docs for multiple groupBy however would expect this would work:

  .groupBy([
    users.user_id,
    exercises.ExerciseID
  ]);

  .groupBy([
    users.user_id,
    exercises.ExerciseID
  ]);

how to achieve this?

1 Reply

McLean 25•16mo ago

I think .groupBy(users.user_id, exercises.id) should work

The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!

9.5KMembers

Want results from more Discord servers?