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 vote140 views1 answer
How to use group_concat in sql server
SQL
1 vote168 views1 answer
Nvl postgres
SQL
1 vote142 views3 answers
What is union in sql
SQL
36 votes264 views6 answers
Change column data type sql
SQL
0 vote140 views1 answer
Show database not empty tables postgres
SQL
2 votes142 views1 answer
Oracle virtual column
SQL
0 vote143 views1 answer
Ignore case in string sql
SQL
0 vote162 views1 answer
Sql last time database was accessed
SQL
244 votes271 views14 answers
Sql n insert
SQL
1 vote134 views2 answers
Into sql
SQL