Last record - more then one

[ves]

Hi guys,

Is there a way to build query to find for example last 5 records from table??

Thanks

[DatabaseMakers]

SELECT TOP 5 YourTable.*
FROM YourTable
ORDER BY YourTable.ID DESC;

..if you have an id in your table!~)

[ves]

Thanks a lot. It works.

Solved.