title: workaround for OVER() in Mysql 5.6
body: <p>I am trying to migrate my existing data from oracle to mysql and am having a constraint of going with Mysql5.6. I have one view in the DB which is using OVER() clause. When I am trying to run the CREATE query in mysql workbench, it straight away gives me a syntex error around OVER().</p>
  
  <p>Can someone please help me with a workaround.</p>
  
  <p>Part of the DDL</p>
  
  <pre><code>COUNT(*) OVER(PARTITION BY mei.ID ORDER BY mei.EVENTDATE ASC ROWS UNBOUNDED PRECEDING) COUNT,
      COUNT(*) OVER(PARTITION BY mei.ID,mei.SUBTRANTYPEVIEW ORDER BY mei.EVENTDATE ASC ROWS UNBOUNDED PRECEDING)
  </code></pre>