不幸的是，MySQL没有您需要的窗口功能。因此，您将必须使用以下内容：
最终查询
select data, group_row_number, overall_row_numfrom( select data, @num := if(@data = `data`, @num + 1, 1) as group_row_number, @data:= `data` as dummy, overall_row_num from ( select data, @rn:=@rn+1 overall_row_num from yourtable, (SELECt @rn:=0) r ) x order by data, overall_row_num) xorder by overall_row_num
参见带有演示的SQL Fiddle
解释：
首先，内部选择，这会将模拟应用于
row_number表中的所有记录（请参阅带有演示的SQL
Fiddle）：
select data, @rn:=@rn+1 overall_row_numfrom yourtable, (SELECt @rn:=0) r
查询的第二部分，将表中的每一行与下一行进行比较，以查看其是否具有相同的值，如果没有，则重新开始
group_row_number（请参见SQL
Fiddle with Demo）：
select data, @num := if(@data = `data`, @num + 1, 1) as group_row_number, @data:= `data` as dummy, overall_row_numfrom( select data, @rn:=@rn+1 overall_row_num from yourtable, (SELECt @rn:=0) r) xorder by data, overall_row_num
最后一个选择，返回所需的值，并将其按您要求的顺序放回去：
select data, group_row_number, overall_row_numfrom( select data, @num := if(@data = `data`, @num + 1, 1) as group_row_number, @data:= `data` as dummy, overall_row_num from ( select data, @rn:=@rn+1 overall_row_num from yourtable, (SELECT @rn:=0) r ) x order by data, overall_row_num) xorder by overall_row_num
