Using Sequelize Subquery

Question

I am completely new to both nodejs and SQL / Sequelize. But I fight my way through!

I have a query here, which I would like to implement with Sequelize. If I am already informed, I can do this with sequelize.literal.

Maybe you can help me.

SELECT ytd.*
FROM youtubedata ytd
WHERE ytd.date = (SELECT MAX(ytd2.date) FROM youtubedata ytd2);

Anatoly · Accepted Answer · 2020-07-14 20:18:30Z

1

Something like this:

const items = await database.youtubedata.findAll({
where: Sequelize.where(Sequelize.col('date'), '=', Sequelize.literal('(SELECT MAX(ytd2.date) FROM youtubedata ytd2)'))
})

answered Jul 14, 2020 at 20:18

Anatoly

23.2k3 gold badges33 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

OliverKhl Over a year ago

With a few minor changes, it worked wonderfully. Thank you!

Collectives™ on Stack Overflow

Using Sequelize Subquery

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related