oix ppl, now I have a question.
I thougth that when you make a SELECT without an ORDER BY, the rows were returned in natural order, that would be some specific order (insertion order, presence in file, I don't know, but the order would be always the same). Is this uncorrect? Is the returning order variable? Thanks, mpneves On Tuesday 10 May 2005 10:37, Harald Fuchs wrote: > 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. -- Marco Paulo Neves MySQL Core Certified Linux Certified Professional http://themage.bliker.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]