mysql分组查询时如何给每一组加一个自增字段
SELECT a.group_id,a.name,IF( IFNULL(@group_ids ,(@group_ids := a.group_id)) = group_id , (@i := @i + 1), (@i := 1 AND ( @group_ids := a.group_id))) AS rowNo FROM test.test a ,(SELECT @i := ...
原创
2020-02-16 17:37:11 ·
2572 阅读 ·
3 评论