Mysql 找出组内连续数字中缺失的数字

select * from group_find_value_test;

每个数组中的数字value，都已2为递增

select b.groupId,min(b.value) as startValue,max(b.value) as endValue from(
	select a.*,(a.value-a.rownum*2) as cc from(
		select @rownum:=@rownum+1 as rownum,groupId,value from (SELECT @rownum:=0) s,group_find_value_test order by groupId,value 
	) as a
)as b group by b.groupId,b.cc;

这样就找出了1组缺失的数字8
2组缺失的数字7