Totally! BETWEEN seems like such a shortcut at first, but it definitely bites you eventually.
Btw, I see on your profile that you work at Euromonitor International, which totally takes me back! In a past internship, I used Euromonitor data to help small companies in Ohio export their products. I couldn't believe the depth and richness of your datasets on everything from flavors of ice cream to pistachio exports (sometimes correlated, haha). Lemme know if you're ever in need of a great SQL editor built for teams :) popsql.com
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Yep! During reviews I beg other developers to avoid
BETWEENclause completely and be explicit about these kind of queries.Totally! BETWEEN seems like such a shortcut at first, but it definitely bites you eventually.
Btw, I see on your profile that you work at Euromonitor International, which totally takes me back! In a past internship, I used Euromonitor data to help small companies in Ohio export their products. I couldn't believe the depth and richness of your datasets on everything from flavors of ice cream to pistachio exports (sometimes correlated, haha). Lemme know if you're ever in need of a great SQL editor built for teams :) popsql.com