MySql单表查询分组之后每组指定个数的数据
SET @codeum := ‘’;
SET @csum := 0;
SELECT * from
(
SELECT si_a.*,
IF(@codeum <> si_a.分组列名 , @csum := 0 , (@csum := @csum + 1) ) AS icount ,
IF(@codeum = si_a.分组列名 , @codeum := si_a.分组列名 ,@codeum...
原创
2019-05-21 17:33:57 ·
1308 阅读 ·
0 评论