MySQL实现ROW_NUMBER()分组功能
方法一:
SELECT IF(@group1=t.entity_name and @group2=t.op_name,@rank:=@rank+1,@rank:=1) AS rank,@group1:=t.entity_name,@group2:=t.op_name,
t.*
FROM (SELECT @group1:='',@group2:='',@rank:=0) g,
(SELECT id,entity_name,entity_id,op_name,`comment`,`user_name`,Data
原创
2021-07-27 16:56:13 ·
477 阅读 ·
0 评论