title: SQL return n rows per row value
body: <p>Greetings SQL people of all nations.  </p>
  
  <p>Simple question, hopefully a simple answer.  </p>
  
  <p>I have an Oracle database table with persons' information. Columns are:</p>
  
  <pre><code>FirstName, LastName, BirthDate, BirthCountry
  </code></pre>
  
  <p>Let's say in this table I have 1500 persons born in Aruba (BirthCountry = "Aruba"), 678 Botswanans (BirthCountry = "Botswana"), 13338 Canadians (BirthCountry = "Canadia").  </p>
  
  <p>What query would I need to write extract a sample batch of 10 records from each country? It doesn't matter which 10, just as long as there are 10.  </p>
  
  <p>This one query would output 30 rows, 10 rows from each BirthCountry.  </p>