--On 22 August 2004 20:31 +0800 Manisha Sathe <[EMAIL PROTECTED]> 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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]