This SQL query appears a bit tricky. We can use BETWEEN clause to get all the employees whose date of birth lies between two given dates.
Query will be as follows:
WHERE birth_date BETWEEN ‘01/01/1990’ AND ‘31/12/2000’
Remember BETWEEN is always inclusive of both the dates.Read the full book at www.amazon.com