Question

What SQL syntax could you use to filter date ranges in your dataset?

Answer 1

The syntax would be

SELECT * FROM TABLE WHERE DATE >= '*date*' AND DATE <= '*date*'

Let say the following is our data for reservations in a cruise.

Now, let say you need to find the reservations after today i.e 28th September. The SQL syntax would be

SELECT * FROM RESERVATION WHERE CruiseDate > '2019-09-28';

You get the results as

If you want the reservations from 15th August to today, the query would be

SELECT * FROM RESERVATION WHERE CruiseDate > '2019-08-15'AND CruiseDate <= '2019-09-28'; and the results,