Quote:Suppose we want a report showing TOP(50) costly items. There may be a situation in which the price of 50th item is same as one or more items down the list. At that point how can we have a better solution? Do we want to include other products that are tied for the same prices as the item in the 50th position?
There is an easy way to solve the problem caused by tied values in the last position of your top list arbitrarily capping the results. And it the SQL clause With TIES
SELECT TOP 50 WITH TIES NAME, PRICE
ORDER BY PRICE DESC
Quote:The result set would have more than 50 items, but the last 2 or more items would be having the same price.