How to get the value from the next record?

Question

How to get the value from the next record?

31 views

Hi all.

I have a query which gives me a bunch of dates

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

I need this query to get each other table with an offset of 1
what would get date of the next record and get this:

the query that is giving me my request

21.04.2016 22.04.2016 23.04.2016 24.04.2016

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

asked Apr 12, 2019 by BashkaMen | 31 views

3 Answers

Related questions

0 like 0 dislike

2 answers

How to fill in the blank lines of the previous value (lag + left join)?

asked Jun 4, 2019 by KTG

0 like 0 dislike

1 answer

How to get a resource from Oracle Sql in Yii 2?

asked Jun 12, 2019 by dishastalker

0 like 0 dislike

1 answer

Why when I try to load data into a table using APEX_APPLICATION_TEMP_FILES I get an error ORA-01403?

asked Apr 26, 2019 by pavel9609

0 like 0 dislike

1 answer

How to get session data oracle?

asked Apr 14, 2019 by gadpaw

0 like 0 dislike

5 answers

Where to get a ready image for a new path?

asked Mar 25, 2019 by 1nd1go

mletov · Answer 1 · 2019-04-18T03:33:18+0000

https://docs.oracle.com/cd/B19306_01/server.102/b1...
\rwww.sql-tutorial.ru/en/book_lag_and_lead_functions.html

PS the Second link for MSSQL, but very clearly

idShura · Answer 2 · 2019-04-18T03:33:18+0000

Try it like this:

SELECT TRUNC (LOGS.DATETIME), LEAD (TRUNC (LOGS.DATETIME), 1, TRUNC(SYSDATE)) OVER (ORDER BY LOGS.DATETIME) NEXT_DATETIME FROM LOGS LOGS WHERE LOGS.ID = 123 ORDER BY LOGS.DATETIME;

How to get the value from the next record?

Please log in or register to add a comment.

Please log in or register to answer this question.

3 Answers

Please log in or register to add a comment.

Please log in or register to add a comment.

Please log in or register to add a comment.

Related questions

Most popular tags