Question

How can we access all the records from database chronologically?

Answer 1

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

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

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