MYSQL利用添加序号，分组查询TOPN数据

分组查询第二次编辑的记录，如无则选择唯一的一次编辑记录
添加序号代码块为网上找到后修改的，有点不太明白，后续还需要深入下。

select 
t.business_chance_id,
max(t.create_time) as create_time
from 
(/*分组递增编号*/
SELECT 
/*判断@type是否和当前的type一样，true:让@r+=1 alse:重置@r*/
	@r:= case when @business_chance_id=a.business_chance_id then @r+1 else 1 end as rowNum,
/*设置 @type等于type*/
	@business_chance_id:=a.business_chance_id as business_chance_id,
	a.create_time
from 
(select * from crm_business_chance_log 
 order by business_chance_id,create_time asc) a ,
(select @r:=0 ,@business_chance_id:='') b
) t
where t.rowNum<=2 /*只选择TOP2的记录*/
group by
t.business_chance_id