title: select top 10 records for each group in sql
body: <p>i have table below field</p>
  
  <p><strong>Hour,PathId,Duration,Event,CellId,Channel</strong></p>
  
  <p>Here each cellid have four pathId(i.e, 0,1,2,3),Each pathId have many Events,Channel and Durations. </p>
  
  <p>Now i want to display top 10 records(each pathId) for each cellid.</p>
  
  <p>(group by cellid, pathid and channel we got duration.. we take top ten each pathid based on duration)</p>
  
  <p>i have 50+ cellid and each cellid have four pathid(i.e, 0,1,2,3)</p>
  
  <p>pls help me</p>
  
  <p>!
  <a href="http://i.stack.imgur.com/9fnJF.png" rel="nofollow">SampleTable</a></p>
  
  <p>!
  <a href="http://i.stack.imgur.com/Iy33c.png" rel="nofollow">outputtable</a></p>