If you have an identity column in your table, you could do something like
WHERE ID_Column IN
(SELECT TOP 4 ID_Column
ORDER BY ID_Column DESC)
It would get more complicated if you don't have an identity field, but still possible based on what sort of data you're storing. If you don't have an identity column, could you share your table layout?
What is the Primary Key (PK) and how do you determine the "order" of the rows in the table? Tables don't have any implicit order, so you need to decide how you want the rows ordered. The PK is the column or columns that uniquely identify each row in your table.