Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Returns a subset of tuples from a specified set.
From the specified set, the Subset function returns a subset that contains the specified number of tuples, beginning at the specified start position. The start position is based on a zero-based index; that is, zero (0) corresponds to the first tuple in the specified set, 1 corresponds to the second, and so on.
If Count is not specified, the function returns all tuples from Start to the end of the set.
The following example returns the Reseller Sales Measure for the top five selling subcategories of products, irrespective of hierarchy, based on Reseller Gross Profit. The Subset function is used to return only the first five sets in the result after the result is ordered using the Order function.
SELECT Subset (Order ([Product].[Product Categories].[SubCategory].members ,[Measures].[Reseller Gross Profit] ,BDESC ) ,0 ,5 ) ON 0 FROM [Adventure Works]