yes, but is there any better way of doing it ? regards Manisha
----- Original Message ----- From: "Karl Pielorz" <[EMAIL PROTECTED]> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 23, 2004 8:34 PM Subject: Re: How to get the last record from the slected record set > > > --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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]