sql - SQLite中ANY关键字的替代

Question

我需要在SQLite中执行查询，但是由于SQLite不支持ANY关键字，是否有任何替代查询会产生相同的结果。

以下是我要在SQLite中执行的查询：

select * from ORDERsy 
where amount < any(select amount from ORDERsy where odate = '06-oct-1999');

Answer 1

您可以使用MAX：

select * 
from ORDERsy 
where amount < (select MAX(amount) from ORDERsy where odate = '06-oct-1999');

从 ALL, ANY and SOME Comparison Conditions in SQL：

“ x