我正在尝试在SQLite中执行以下查询:
SELECT *
FROM customers
WHERE rating = ANY
(SELECT rating
FROM customers
WHERE city = 'Rome');
但是收到了这个错误:
Query Error: near "SELECT": syntax error Unable to execute statement
如果我更换
rating = ANY
到rating IN
,一切正常。有人可以告诉我在SQLite中的任何语句如何工作以及我在做什么错吗?
最佳答案
AFAIK,SQLite没有ANY
运算符。但是,您可以使用IN
运算符来获取所需的功能:
SELECT *
FROM customers
WHERE rating IN -- Here!
(SELECT rating
FROM customers
WHERE city = 'Rome');