adam-beck
adam-beck
PostsComments
DTDrizzle Team
Created by Liam on 7/5/2023 in #help
Drizzle Count # of Records
Taken from here: https://orm.drizzle.team/docs/sql#sql-select
7 replies
DTDrizzle Team
Created by Liam on 7/5/2023 in #help
Drizzle Count # of Records
Have you tried 
const totalUserCount = await db.select({ count: sql<number>`count(*)`.mapWith(Number) }).from(users);
const totalUserCount = await db.select({ count: sql<number>`count(*)`.mapWith(Number) }).from(users);
7 replies