title: Can you please provide me the my sql query for below situation
body: <pre><code>    buildname   versionname   methodresult
      b1          v1            success
      b1          v2            failure
      b2          v1            success
      b2          v1            failure
      b1          v2            skip
      b2          v1            skip
      b3          v1            success        
      b3          v2            success
  </code></pre>
  
  <p>in above example i need to get only <strong>buildname</strong> <strong>b3</strong> which has only <code>success not filure or skip</code> using <code>mysql</code>.</p>
  
  <p><strong>i need to get all buildnames which has success as method result .if one buildname has both success and failure i don't need that buildname even having success in any row.</strong></p>
  
  <p>thank you</p>