>我正在尝试在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');
好吧,SQLite 中没有 ANY
关键字,因此它不起作用。