* Manisha Sathe > 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?
Try this: order by score desc LIMIT 9,1 -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]