How to get the value from the next entry?

Question

Oracle

Hello.
I have a query that gives me a bunch of dates

select trunc(logs.DATETIME) from Logs logs
where logs.Id = 123
order by logs.DATETIME

I need in this query how to overlay tables with an offset of 1
to get the date of the next record and get this:
query - this is what my query gives me

21.04.2016
22.04.2016
23.04.2016
24.04.2016

I want to get this:

21.04.2016 22.04.2016
22.04.2016 23.04.2016
23.04.2016 24.04.2016
24.04.2016 *sysdate*

If I have ORACLE

Answer 1

https://docs.oracle.com/cd/B19306_01/server.102/b1...
www.sql-tutorial.ru/en/book_lag_and_lead_functions.html
PS Second MSSQL link, but very descriptive

Answer 2

The LEAD function is what you need