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 vote202 views2 answers
How to check if sqlite table exists in nodejs
SQL
24 votes185 views5 answers
Sql reset auto increment
SQL
3 votes194 views2 answers
Order by postgresql
SQL
1 vote186 views1 answer
How to drop function in sql
SQL
1 vote201 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote180 views1 answer
Database xml sql
SQL
2 votes168 views2 answers
How to get capital letter first in sql
SQL
-1 vote178 views3 answers
Check table exist postgresql
SQL
9 votes199 views3 answers
Find all tables with column name
SQL
0 vote221 views1 answer
Find wordpress version in database
SQL