mysql取某个组的前n条数据

取每个partyid的前三条数据：

SELECT * FROM partyphotos b

WHERE    b.PartyId IN (SELECT PartyId FROM partyphotos)

GROUP BY

CONCAT(b.PartyId, b.Id % 3)