Re: How to get the last record from the slected record set

[Karl Pielorz]

--On 22 August 2004 20:31 +0800 Manisha Sathe <manisha@stripped> 
wrote:

> 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 ?

order by score asc limit 1

[i.e. turn it around and pick the 1st (which will be the last because it's 
ordered the other way)]

:-)

-Kp