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