title: MySQL Convert ROW_NUMBER() OVER PARTITION
body: <p>I'm trying to convert an MSSQL database to MySQL and my version is 5.7. I have hit a roadblock.</p>
  
  <pre><code>SELECT orderid, invs.[InvoiceID],  invs.[InvoiceDate],
  invs.[InvoiceNumber], invs.[HasClientPaid],
  ROW_NUMBER() OVER (PARTITION by orderid,invs.invoicenumber,HasClientpaid ORDER BY orderid) AS DistNum 
  FROM InvoiceLineItems Ilt 
  JOIN Invoices Invs ON Ilt.InvoiceID= invs.InvoiceID
  </code></pre>
  
  <p>Any help would be greatly appreciated. Thank you</p>