Dear Experts,
I have a table , it has Date and Stutus fields
Date Status
==== ======
2019-03-01 0
2019-03-02 0
2019-03-03 0
2019-03-04 0
2019-03-05 0
2019-03-06 0
2019-03-07 0
like this
when i change date through application status will be immediatly change status=1
how to write a query in sql