In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes: > hi, > your need is: > select * from temp LIMIT 3,4; > -- 3 because you have to take the fourth and 4 because dist=3+1
This does not make sense. A SELECT without an ORDER BY returns the rows in some undefined order. If you use "LIMIT 3,4" without ORDER BY, you get four rows out of an unordered set, so it's virtually identical to "LIMIT 4". As long as the original poster doesn't say what ordering he wants, there's no way to tell him a solution. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]