title: why top 5 with ties not giving complete record sets
body: <p>My query result should give top 5 with ties records but the query mentioned below is giving 130,130,120,120,120,120,120,120,120,120 </p>
  
  <p>but I want the result as
  130,130,120,120,120,120,120,120,120,120,110,100</p>
  
  <pre><code>select top 5 with ties b.quantity
  from dbo.Products as a
  inner join dbo.[Order Details] as b
  on a.productid = b.productid
  inner join dbo.Suppliers as c
  on c.supplierid = a.supplierid
  order by quantity desc
  </code></pre>
  
  <p>I am not able to understand why the above query is not including 110 and 100 numbers even after including Top 5 with ties.</p>