How to select date between date range in SQL MySQL

Suppose we have a table namely attendance.  If you  want to show data  till 4th April,  you can just use this sql query.

SELECT * from attendance where Date <‘2018-04-10’;

Leave a Reply