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 

Reply via email to