[Solved] Get entries stored in database from yesterday [duplicate]

Question

Or you could use BETWEEN aside from TOP statement like:

SELECT TOP(10) * FROM table1 WHERE cat = 1 and  
datee BETWEEN DATEADD(day, -1, @dt) AND @dt 
ORDER BY datee DESC

Accepted Answer

Or you could use BETWEEN aside from TOP statement like:

SELECT TOP(10) * FROM table1 WHERE cat = 1 and  
datee BETWEEN DATEADD(day, -1, @dt) AND @dt 
ORDER BY datee DESC