title: Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
body: <p>Are there any functions in MySQL like <code>dense_rank()</code> and <code>row_number()</code> like those provided by Oracle and other DBMS?</p>
  
  <p>I want to generate an id within the query, but in MySQL these functions are not there. Is there an alternative?</p>