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