Question

How can we access all the records from database chronologically? I need the records for a particular date and a syntax for accessing the data between two particular dates of birth (from and to).

Answer 1

In order to access the records for a particular date, you will need to use the following syntax:

SELECT * FROM TableName
WHERE Date="dd/mm/yyyy";

In order to access the data between two particular dates of birth, you can use one of the following statements:

SELECT * FROM TableName
WHERE Date BETWEEN "dd/mm/yyyy" AND "dd/mm/yyyy";

or

SELECT * FROM TableName
WHERE Date >= "dd/mm/yyyy" AND  Date <= "dd/mm/yyyy";