title: Top value of salary form employees in every country SQL
body: <p>This is my database:</p>
  
  <ul>
  <li>Table Country: id integer (pk), varchar name,</li>
  <li>Table Employe: id integer (pk), countryid integer(fk), varchar name, integer salary.</li>
  </ul>
  
  <p>I want to display employees with the highest salary in every country, but I can display only one employer with the highest salary.</p>
  
  <p>This is my SQL query:</p>
  
  <pre><code>Select * 
  from Employe 
  order by Employe.salary 
  desc LIMIT 1;
  </code></pre>