Limit in access query

There is no LIMIT keyword in Access (if you use the JET engine). You can use TOP x to give the first x results. Usage:
select Top 5 * from table_name order by column_name

Source: stackoverflow.com

Similar codes

0 vote132 views1 answer
Bitmap join index
SQL
1 vote115 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote115 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote129 views1 answer
Sql alter table add column if exists
SQL
0 vote131 views1 answer
Pl sql disable trigger
SQL
0 vote111 views1 answer
Mysql query to add hours to column in table
SQL
-1 vote125 views1 answer
How to change the auto increment in existing table mysql
SQL
3 votes112 views3 answers
Update join
SQL
15 votes112 views2 answers
How to drop database name in postgresql
SQL
0 vote133 views1 answer
Query params sql insert python f string
SQL