title: Unable to use rank() over functions in R using sqldf
body: <pre><code>arm&lt;-as.data.frame(matrix(c(1,1,1,2,2,6,7,4,9,10),ncol=2))
  
  colnames(arm)&lt;-c(&quot;a&quot;,&quot;b&quot;)
  </code></pre>
  <p>This is a dataset I created in R.</p>
  <p>Now I want to rank the column b and group by column a.</p>
  <p>The following piece of code is throwing this error, no matter what changes I make to the syntax(like adding [], &quot;&quot;, etc...)</p>
  <blockquote>
  <p><em><strong><strong>Error in sqliteSendQuery(con, statement, bind.data) :    error in statement: near &quot;(&quot;: syntax error</strong></strong></em></p>
  </blockquote>
  <p>I was using &quot;sqldf&quot; package.</p>
  <pre><code>arm2&lt;-sqldf(&quot;select a,
           b,
           rank() over (partition by a order by b) as rank1 
           from arm&quot;)
  </code></pre>
  <p>Then I installed the RH2 package and it started to throw the following error:</p>
  <blockquote>
  <p><em>Error in .verify.JDBC.result(s, &quot;Unable to execute JDBC statement &quot;, statement) :    Unable to execute JDBC statement select a,
  b,
  rank() over (partition by a order by b) as rank1
  from arm (Function &quot;rank&quot; not found; SQL statement: select a,
  b,
  rank() over (partition by a order by b) as rank1
  from arm [90022-175])</em></p>
  </blockquote>
  <p>How to use rank() over function of sql in sqldf package of R?</p>