How to get the last record from the slected record set

[Manisha Sathe]

I am having more than 10 records in a table. I want to select only first top 10 records
(depending on one field score) and then want to select 10th position record.

select * from table1 order by score desc LIMIT 10

This will give me 10 records but then how to get the last record ?

Thanks in advance,

regards
Manisha