How to return column changes in a column

Asked Sep 28 '22 at 20:23

Active Sep 28 '22 at 20:24

Viewed 23 times

I have a table with a list on dates, and all I want to do is return the changes from row to row.

For example:

id   date
1     2022-08-30
2     2022-08-31
3     2022-09-01
4     2022-09-02
5     2022-09-02
6     2022-09-05

and I would like to return something like "The date changed from 2022-08-30 to 2022-08-31" and "The date changed from 2022-08-31 to 2022-09-01" and so on.

Thank you in advance.

edited Sep 28 '22 at 20:24

Dale K

25,246
15
42
71

asked Sep 28 '22 at 20:23

Bryan

3

Have you tried `LEAD` and/or `LAG`? – Dale K Sep 28 '22 at 20:24
1

I wasn't aware of LEAD, but this looks like exactly what I'm looking for. thank you so much. – Bryan Sep 28 '22 at 20:29

How to return column changes in a column

0 Answers0