title: Multiple Ranks in one table
body: <p>I need the following, Can anyone please help me do it.</p>
  
  <pre><code>Rank   Cust_Type   Cust_Name   Revenue
  1      Top         A           10000
  2      Top         B           9000
  3      Top         C           8000
  1      Bottom      X           5000
  2      Bottom      Y           6000
  3      Bottom      Z           7000
  </code></pre>
  
  <p>I need separate ranks for Top and Bottom Cust_Type and all this is in MySQL.</p>