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

1 vote205 views1 answer
Error code 1292 mysql workbench
SQL
0 vote185 views1 answer
Deny select insert update delete sql
SQL
0 vote183 views1 answer
Mysql percentage of total
SQL
0 vote201 views1 answer
Insensitive case match sqlalchemy
SQL
9 votes198 views4 answers
Mysql set id auto increment
SQL
6 votes190 views5 answers
Alter table oracle
SQL
-1 vote210 views1 answer
Add 10 to all numbers in a column sql
SQL
4 votes203 views2 answers
Sql server date now
SQL
0 vote188 views1 answer
Set engine to innodb
SQL
-1 vote189 views1 answer
Module operator in oracle sql
SQL