How do I implement this SQL query in Ruby on Rails

Question

I have this delicious SQL query here that im trying to figure out how to implement in rails using their active record methods ==> .select() .where() ect...

SELECT topics.id FROM topics WHERE NOT EXISTS ( SELECT * FROM votes WHERE votes.topic_id = topics.id )

Dnyanarth lonkar · Accepted Answer · 2017-03-30 07:00:44Z

1

Try this

@topics = Topic.where("not exists (SELECT * FROM votes WHERE votes.topic_id = topics.id)")

answered Mar 30, 2017 at 7:00

Dnyanarth lonkar

8697 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

How do I implement this SQL query in Ruby on Rails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related