我有一个SQL查询
SELECT * FROM students
EXCEPT
SELECT * FROM students WHERE val->>'rating' = 'Fail'
如何在Rails范围内实现相同的结果?
SELECT * FROM students
EXCEPT
SELECT * FROM students WHERE val->>'rating' = 'Fail'
等于
Student.where("val->>'rating' IS DISTINCT FROM ?", 'Fail')