How do I retrieve only the first n records using query in MS access

I a开发者_如何学运维m looking for something like rownum

You can use TOP, for example:

SELECT Top 10 col FROM Table ORDER BY col2

Note that this will return more than 10 records if col2 has duplicates.

Select Top n Col From Table