Need a particular row value from table.

Hi,
How do i get the nth row value in a table in sql server. For example i wanted a particular field value of the 10 row in a table how do i get it. is there any query for that. Please help me out in this.Thanks in advance.
Regards
Vinoth

Code:

---

DECLARE @field INT
 
SELECT top 10 @field=field from MyTable
SELECT @field field

---

Hope that helps

How would one do this in Access 2002?