Selecting x number of rows within group

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

mbarrentine SSC Enthusiast Points: 102 More actions · Answer 1

Here's a working example using the Northwind DB:

USE Northwind

SELECT P.*

FROM Products P

WHERE P.ProductID IN ( SELECT TOP 2 G.ProductID

FROM Products G

WHERE G.CategoryID = P.CategoryID

)

ORDER BY P.CategoryID