DEV Community

quanjongliang
quanjongliang

Posted on

Sequelize query * with count by field

Hi everyone

Can you help to rewrite this raw query by sequelize? Thanks

`select * ,
(select COUNT(*)
from outreachcontacts
where primaryContact = table_alisa.primaryContact
) as count

from outreachcontacts as table_alisa `

Top comments (0)