title: SQL Query to compare the quarterly results for the top 5 salesperson
body: <p>I have data with order amount for salesperson from 2003 Q3 to 2005 Q2, I would like to show the results of each quarter, salesperson and total order amount for top 5 salesperson.</p>
  
  <p>I have this sql statement</p>
  
  <pre><code>select DATEPART (Year, [Order Date]) AS Year,
         DATEPART (QUARTER,[Order Date]) As Quarter, 
         Salesperson, 
         SUM([Order Amount]) As [Total Order Amount] 
  from dbo.tbl_sales 
  Group By DATEPART (YEAR, [Order Date]),  
           DATEPART (QUARTER, [Order Date]), 
           Salesperson 
  Order By  SUM([Order Amount]) DESC
  </code></pre>
  
  <p>but it is not only showing the top 5 sales person, please help.</p>