Strange limit and offset behaviour....

I have the following sql:

SELECT * from table order by dato asc limit 20 offset 0

This gives me different rows than the 20 first rows when running the following sql:

SELECT * from table order by dato asc

Shouldn't the 20 first rows in the second sql statment be the same 20 rows that is returned in the first statement
or am I missing something?

Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj(at)havleik(dot)no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------