title: SQL Query - Finding rows for a highest index number
body: <p>I am struggling to find a correct way to query the following scenario. Consider the below table as example, where I want the row with index_no 124 for that dvpc and pid value of the columns. Please suggest.</p>
  
  <pre><code>Index_No    dvpc     pid     rate
  123         123      30      0.01
  124         123      30      0.02
  </code></pre>