title: how do I get certain numbers of rows per unique column?
body: <p>I'm using postgresql and I have two columns Country and Name. I want to get x numbers of people's name for each country. </p>
  
  <p>so forexample if I had a data like this</p>
  
  <pre><code>Name    Country
  "John"  "US"
  "Kim"   "KR"
  "Mike"  "US"
  "Park"  "KR"
  "Kim"   "US"
  "Doe"   "RU"
  "Pou"   "KR"
  "John"  "RU"
  "Sam"   "RU"
   ...    ...
   ...    ...
  </code></pre>
  
  <p>and say I want to get 2 ppl name for each country</p>
  
  <pre><code>Name    Country
  "John"  "US"
  "Mike"  "US"
  
  
  
  "Park"  "KR"
  "Pou"   "KR"
  
  
  
  "Sam"   "RU"
  "Doe"   "RU"
  </code></pre>
  
  <p>is there a way to do this kind of stuff? </p>