我正在尝试在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 = ANYrating IN,一切正常。

有人可以告诉我在SQLite中的任何语句如何工作以及我在做什么错吗?

最佳答案

AFAIK,SQLite没有ANY运算符。但是,您可以使用IN运算符来获取所需的功能:

SELECT *
FROM   customers
WHERE  rating IN -- Here!
       (SELECT rating
        FROM   customers
        WHERE  city = 'Rome');

10-07 19:21
查看更多