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



Reply via email to