Since 85, and 86 lines of resource_id, in essentially how to 86 line enname, phone and time in 85 lines of next_enname, next_phone and next_time

CodePudding user response:

Select
B.r esource_id,
B.a pply_reason,
B.t ime,
(select time from
(select *, row_number () over (partition by resource_id order by resource_id) xx from table name) a
Where a.r esource_id=b. resource_id and a.x x=2 and b.x next_time x=1))
The from
(select *, row_number () over (partition by resource_id order by resource_id) xx from table name) b