[synapse5150]

I thought this would be an easy SQL question, but I haven't found anyone who can help me.
I have a table with 3 fields: PERSONID, CONTACTID, and ORDERID. I need to pull the top 3 ORDERID's for each distinct PERSONID.
I would appreciate any help I can get with this, and I thank you all in advance!

[Advertisements]

Here's the solution I came up with (Thanks Peso, Patron Saint of Lost Yaks):

SELECT MyTable.ContactID, MyTable.OrderID
FROM MyTable
WHERE MyTable.OrderID IN (SELECT TOP 3 x.OrderID FROM MyTable AS x WHERE x.ContactID = MyTable.ContactID)
ORDER BY MyTable.PersonID

[synapse5150]

Here's the solution I came up with (Thanks Peso, Patron Saint of Lost Yaks):

SELECT MyTable.ContactID, MyTable.OrderID
FROM MyTable
WHERE MyTable.OrderID IN (SELECT TOP 3 x.OrderID FROM MyTable AS x WHERE x.ContactID = MyTable.ContactID)
ORDER BY MyTable.PersonID