Hi, I am having a problem with an SQL query and a friend has a book of mine I know has the answer. So I decided to ask here instead.

I am using JSP with an Access database and need to make an SQL query which returns the first four results in a resultset.

I know I could just get all the results, and only take the first four results from the set, but I figured it is more efficient if I use an SQL query which only returns the first four results.

The query which returns everything is
SELECT *
FROM TableName
ORDER BY FieldName desc;

Would be great if someone could help me with the count function or whatever to only return the first four results from the above query.

Thanks