I have data like this,
ID |
Date |
1 |
2018-1-10 |
2 |
2018-1-12 |
3 |
2018-1-13 |
4 |
2018-1-15 |
5 |
2018-1-17 |
6 |
2018-1-18 |
7 |
2018-1-20 |
8 |
2018-1-21 |
I need query which is return missing dates from date column like ‘2018-1-11’ , ‘2018-1-14’.
Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly