CODEWITHSUNDEEP
sqlms-accessrownum
user17223
user17223

Reputation:

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

I am looking for something like rownum

Upvotes: 1

Views: 9713

Answers (2)

Fionnuala
Fionnuala

Reputation: 91326

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.

Upvotes: 2

jim
jim

Reputation: 27396

Select Top n Col From Table

Upvotes: 0

Related Questions