title: Firebird SQL Nested Select
body: <p>I cant realize whats wrong with my query (Firebird SQL):</p>
  
  <pre><code>select max(column1) from (select first 100 column1 from table1 where column1 &gt; 0) p
  </code></pre>
  
  <p>Error message:</p>
  
  <pre><code>SQL Message : -104
  Invalid token
  Message: isc_dsql_prepare failed
  SQL Message : -104
  Invalid token
  Engine Code    : 335544569
  Engine Message :
  Dynamic SQL Error
  SQL error code = -104
  Token unknown 
  </code></pre>
  
  <p>Any help is appreciated!</p>