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 vote134 views3 answers
Execute sp in sql server
SQL
0 vote134 views1 answer
How to list function in psql
SQL
1 vote134 views1 answer
Select if then postgresql
SQL
0 vote144 views1 answer
Get max salary from each department sql
SQL
2 votes156 views3 answers
Sql function
SQL
3 votes97 views1 answer
System.debug apex
SQL
1 vote134 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote158 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote147 views1 answer
Providername system.data. mysql
SQL
0 vote138 views1 answer
Mariadb cast to int
SQL