mysql实现rownum:
set @index:=0;
select * from (
select @index:=case when @uid=uid then @index+1 else 1 end as idex, @uid:=uid as uid
from (select uid from tb group by uid);
设置变量@index,并且赋值0,在如果uid改变那么@index将重新计时。
mysql实现rownum:
set @index:=0;
select * from (
select @index:=case when @uid=uid then @index+1 else 1 end as idex, @uid:=uid as uid
from (select uid from tb group by uid);
设置变量@index,并且赋值0,在如果uid改变那么@index将重新计时。