我可以使用SQL的CURSOR检索上一行的值吗？

DECLARE @prev_value INT;
DECLARE @current_value INT;

DECLARE cursor_name CURSOR FOR
SELECT column_name FROM table_name;

OPEN cursor_name;

FETCH NEXT FROM cursor_name INTO @current_value;

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 在这里处理上一行的值
    -- 例如：
    PRINT @prev_value;

    -- 更新上一行的值
    SET @prev_value = @current_value;

    -- 获取下一行的值
    FETCH NEXT FROM cursor_name INTO @current_value;
END

CLOSE cursor_name;
DEALLOCATE cursor_name;