title: SQL query to find the highest paid salary for each lanauges
body: <p>As I am not expert in writing the SQL queries so want for help.
  I have a table called programmer whose structure &amp; data look like:</p>
  
  <pre><code>PNAME,PROF1,PROF2,SALARY
  </code></pre>
  
  <p>In prof1 data are:</p>
  
  <blockquote>
    <p>PASCAL,CLIPPER,COBOL,CPP,COBOL,PASCAL,ASSEMBLY,PASCAL,BASIC,C,PASCAL,FOXPRO.</p>
  </blockquote>
  
  <p>In prof2 data are:</p>
  
  <blockquote>
    <p>BASIC,COBOL,DBASE,DBASE,ORACLE,DBASE,CLIPPER,C,DBASE,COBOL,ASSEMBLY,BASIC,C.</p>
  </blockquote>
  
  <p>In salary data are:</p>
  
  <blockquote>
    <p>3200,2800,3000,2900,4500,2500,2800,3000,3200,2500,3600,3700,3500.</p>
  </blockquote>
  
  <p>I need a query to display the names of highest paid programmer for each language, which means I need to display the maximum salary &amp; person name for each language.
  I tried my best to get the result but didn't get the answer.
  Can you help me?</p>