利用mysql的变量来实现:
set @lag:=0,@currs:=0,@rank:=0;
SELECT name,@lag:=@currs as lag,(@currs:=acct_no) as current_value,@rank:=if(@currs<>@lag,@rank:=@rank+1,@rank) as rank
from a_acct ORDER BY acct_no;利用mysql的变量来实现:
set @lag:=0,@currs:=0,@rank:=0;
SELECT name,@lag:=@currs as lag,(@currs:=acct_no) as current_value,@rank:=if(@currs<>@lag,@rank:=@rank+1,@rank) as rank
from a_acct ORDER BY acct_no;