Input:
Localcol id
2021-03-01 1
2021-03-02. 2
2021-03-03. 3
2021-03-07. 4
2021-03-09. 5
And I want the output as shown below:
Localcol id
2021-03-01 1
2021-03-02 2
2021-03-03. 3
2021-03-04. Null
2021-03-05 Null
2021-03-06. Null
2021-03-07 4
2021-03-08. Null
2021-03-09. 5
Pls help me in creating query