You need to sort the results using
order by
clause. The sort order will be descending as you need the newest at the top. So the query will be like:
SELECT * FROM TABLE_NAME ORDER BY DATE_COLUMN_NAME DESC
This will give you all the results. Now filter the rows using
top
clause.
Hope this helps!