在有序嵌套子查询中访问父标识符

I need a query to get the value of an item together with the value of the previous item if exists.I need a query to get the value of an item toge