MySQL 分类取前N条 sql 写法

FROM (SELECT @num:=0,@AAA:= 0) temp JOIN
(
   SELECT 
   @num := IF(@AAA = parentid, @num + 1, 1) AS row_number,
   @AAA := parentid AS Dummy, mt.* 
  FROM your_table mt 
  WHERE 1=1 
  ORDER BY parentid, orderid ASC
) AS X WHERE x.row_number <= 3;

说明: 

parentId 是原始表 your_table 中要分组的字段

order by 中 要对此字段进行排序, 当然也可以加入其他排序字段(如: orderid)

x.row_number <= 3: 指的是取前3条数据