Thanks to all of, I could get it.... Thanks Manisha
----- Original Message ----- From: "Karl Pielorz" <[EMAIL PROTECTED]> To: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 23, 2004 9:52 PM Subject: Re: How to get the last record from the slected record set > > > --On 22 August 2004 21:05 +0800 Manisha Sathe <[EMAIL PROTECTED]> > wrote: > > > I want to select first 10 records out of 100. And then get the 10th > > position. > > > > If i make use of > > > > order by score asc limit 1 > > > > then I will get 100th record, How shall i pick up 10th position? > > I'm not quite sure I follow what you're aiming for, but have you tried... > > limit 10,1 > > i.e. return 1 record, starting at row 10 in the result set. Beyond that > you'd have to explain what 'score' is, as it's getting a little > confusing... :) > > -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]