© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago
jakeleventhal

How do you compare counts in a query?

WHERE (SELECT COUNT(*) FROM products p WHERE p.productSetId = ps.id) = 
      (SELECT COUNT(*) FROM products p 
       INNER JOIN listingVariants lv ON p.id = lv.productId 
       WHERE p.productSetId = ps.id);
WHERE (SELECT COUNT(*) FROM products p WHERE p.productSetId = ps.id) = 
      (SELECT COUNT(*) FROM products p 
       INNER JOIN listingVariants lv ON p.id = lv.productId 
       WHERE p.productSetId = ps.id);

how would you do this in drizzle without just using the sql operator
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

how do you pass a query in a typesafe way?
Drizzle TeamDTDrizzle Team / help
3y ago
How do you infer the type of a relations query?
Drizzle TeamDTDrizzle Team / help
3y ago
How do you create a scalar subquery in drizzle?
Drizzle TeamDTDrizzle Team / help
3y ago
Compare enums in select
Drizzle TeamDTDrizzle Team / help
3y ago