title: Rank function in MySQL
body: <p>I need to find out rank of customers. Here I am adding the corresponding ANSI standard SQL query for my requirement. Please help me to convert it to MySQL .</p>
  
  <pre><code>SELECT RANK() OVER (PARTITION BY Gender ORDER BY Age) AS [Partition by Gender], 
    FirstName, 
    Age,
    Gender 
  FROM Person
  </code></pre>
  
  <p>Is there any function to find out rank in MySQL?</p>