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

8 votes149 views1 answer
Oracle all_source package body
SQL
0 vote157 views2 answers
How to find max and min salary in sql
SQL
0 vote182 views1 answer
Mysql subtract month from timestamp
SQL
2 votes167 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote157 views1 answer
Postgresql linux password
SQL
2 votes153 views4 answers
Mysql select into new table
SQL
0 vote158 views1 answer
Mysql change innodb to myisam
SQL
1 vote144 views1 answer
Apex ORA-20999
SQL
1 vote156 views1 answer
Rename table column name in mysql
SQL
0 vote147 views1 answer
Mysql multiple primary keys
SQL