SELECT column1, LEAD(ended_date) OVER (ORDER BY id DESC) AS last_row_ended_date, 
	LEAD(id) OVER (ORDER BY id DESC) AS last_row_id
FROM my_table