title: Selecting a specific row from table using sql but getting expected result
body: <p>I have a table as below: </p>
  
  <pre><code>No  Percent date    
  123 0.25    20061026    
  123 0.75    20040126    
  123 0.25    20061126    
  123 0.25    20061226    
  </code></pre>
  
  <p>I wanted o/p only one row with the lowest date as below</p>
  
  <pre><code>123 0.75    20040126                
  </code></pre>
  
  <p>But using below query</p>
  
  <pre><code>select no,percent, min(date) 
  from a 
  group by pno,percent            
  </code></pre>
  
  <p>I am getting 2 rows</p>
  
  <pre><code>123 0.25    20061026    
  123 0.75    20040126    
  </code></pre>
  
  <p>I am i doing anything wrong here?</p>