You can use a query something like this to get the result you are looking for.
SELECT TOP 1*
SELECT TOP (5) *
ORDER BY SomeColumn DESC
ORDER BY SomeColumn ASC</pre>
SomeColumn is what ever column, or columns you need to use in order to get the values in the table in the correct order. It can be an integer, datetime, etc.
I have used this link for reference as well