title: Sql Pivot top N rows only
body: <p>I have Following structure</p>
  
  <pre><code>Col1 Col2 Col3  
  ---------------
  F     P    R1
  F     P    R2
  F     P    R3
  F     P    R4
  </code></pre>
  
  <p>Col3 values can be any thing
  Now I want in following format only top 3 </p>
  
  <pre><code>Col1 Col2 Res1 Res2 Res3  
  ------------------------------
  F     P    R1   R2   R3
  </code></pre>