How can I order and/or limit rows from leftJoin?
I have two tables, groups and exams, exam must have only group, group can have many exams. I'm selecting from groups and I want to select the latest exam with it (order by timestamp column). But I can't find anything like it in the drizzle orm docs, is is possible?
4 Replies
Does this work?
https://orm.drizzle.team/docs/rqb#order-by
Relational queries – DrizzleORM
Drizzle ORM | %s
I am not using relation queries, because I have Mariadb instead mysql and it does not seem to work
I see
sorry I coudln't help
Looks like I managed to get it working using subquery
But thank you!