How to find missing date in sql table.


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’.

 


Asked by:- RameshwarLate
0
: 1020 At:- 12/11/2018 9:08:40 AM
sql date









Login/Register to answer
Or
Post answer directly by entering your email-id & Name

Full Name *

Email *




By posting your answer you agree on privacy policy & terms of use

Subscribe Now

Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly