Answer the question
In order to leave comments, you need to log in
Is it possible to solve this problem using Window Functions?
Help me to understand.
There is a table that contains data like:
code | mod_date
-------------------------------
1 | 2015-10-01 10:00:00
1 | 2015-10-13 22:01:00
2 | 2015-10-13 23:10:00
2 | 2015-10-29 14:00:00
1 | 2015-10-30 11:01:00
1 | 2015-11-01 06:50:00
3 | 2015-11-03 10:00:00
code | mod_date | n_date
-------------------------------------------------------
1 | 2015-10-01 10:00:00 | 2015-10-01 10:00:00
1 | 2015-10-13 22:01:00 | 2015-10-01 10:00:00
2 | 2015-10-13 23:10:00 | 2015-10-13 23:10:00
2 | 2015-10-29 14:00:00 | 2015-10-13 23:10:00
1 | 2015-10-30 11:01:00 | 2015-10-30 11:01:00
1 | 2015-11-01 06:50:00 | 2015-10-30 11:01:00
3 | 2015-11-03 10:00:00 | 2015-11-03 10:00:00
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question