Why does the following query return all rows and not just two rows?

SELECT MyField FROM MyTable where MyField in (Select first 2 MyField
from MyTable)

This might seem a strange thing to want to do but not so when the
two tables are different.

Regards
Peter Gore