title: ROW_NUMBER() OVER () with order by in H2
body: <p>i'm trying to execute a query on a table in H2 database with ROW_NUMBER clause. Here is my query:</p>
  
  <pre><code>SELECT ROW_NUMBER() OVER (order by data), name FROM students
  </code></pre>
  
  <p>But i get an error in H2 console: </p>
  
  <blockquote>
    <p>Syntax error in SQL statement "SELECT ROW_NUMBER() OVER (order[*] by data), name FROM students"; expected ")";</p>
  </blockquote>
  
  <p>I noticed that it only works if OVER clause is empty like OVER();</p>
  
  <p>Any ideas?</p>