SQLite syntax for "ALL"

sqlite

Solution

I doubt that there is an ALL() operator in SQLite. However, you can write something that is functionally equivalent using MAX() and MIN().

SELECT name 
FROM table 
WHERE number >= (SELECT MAX(another_number) FROM another_table WHERE ...)

Problem

Is there a way to do the following in SQLite? ``` select name from table where number >= ALL (<subquery, "such as select x from table ...">) ``` Specifically, I'm getting a syntax error after the `ALL` operator, no matter how I format my query. In my googling for a solution, I found some mention that the syntax for `ALL` is different in SQLite, but I can't seem to figure it out. Can someone show me how a basic `ALL (<subquery>)` statement works in SQLite? Or let me know if they don't work at all?

Original source