troubleshooting Question

Adding a new date field which leads the current date by one record

Avatar of efferz
efferz asked on
SQL
2 Comments1 Solution200 ViewsLast Modified:
Hi,

having a table A which looks like

DATE              X       Y
31/01/1990     20    40
25/02/1990    30    12
30/03/1990    15     30
28/04/1990    14    50

How to query this table in order to get the following result in which a new field NEXT_DATE was added which contains the DATE following the current date (and for the last record the next month´s end).

DATE              X       Y       NEXT_DATE
31/01/1990     20    40       25/02/1990
25/02/1990    30    12        30/03/1990
30/03/1990    15     30       28/04/1990
28/04/1990    14    50        31/05/1990

Regards,
Martin
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros