Answer for Use of Between And in SQL

https://365datascience.com/dwqa-answer/answer-for-use-of-between-and-in-sql/ -

Hi Neelanjan!

Thanks for reaching out.

It is normal to obtain non-null results only in the second case because numbers grow linearly from smaller to bigger when using BETWEEN-AND. That’s why with your first query, where you indicate the interval from a bigger to a smaller date value, you obtain an empty output, while with the second query, where the interval has been indicated from a smaller to a bigger date value, you obtain an output containing many rows of data.

Hope this helps.
Best,
The 365 Team

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy