I have 3 columns
| Manager | Start_Year | End_Year |
|---|---|---|
| Suresh | 2016 | 2017 |
| Suresh | 2017 | 2018 |
| Alok | 2018 | 2019 |
| Suresh | 2019 | 2020 |
I want output like this:
| Manager | Start_Year | End_Year |
|---|---|---|
| Suresh | 2016 | 2018 |
| Alok | 2018 | 2019 |
| Suresh | 2019 | 2020 |
SQL update query to update end date with start date
Viewed 27
0 Answers
Related