select emp_no,salary,convert((@i:=@i+salary),signed) as running_total from salaries s , (select @i:=0 )t where to_date='9999-01-01'
select emp_no,salary,convert((@i:=@i+salary),signed) as running_total from salaries s , (select @i:=0 )t where to_date='9999-01-01'
牛客博客，记录你的成长
京公网安备 11010502036488号