Re: SELECT Row Numbers?

[Harald Fuchs]

In article <1115681350.427ff24647102@stripped>,
mfatene@stripped 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.