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 vote174 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
26 votes164 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote184 views1 answer
Mysql timediff
SQL
1 vote178 views1 answer
Adding a check statement in sql
SQL
0 vote178 views1 answer
Sql contains vs like
SQL
0 vote177 views1 answer
How to update sql server version
SQL
3 votes162 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote165 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
2 votes181 views3 answers
Oracle show column of table
SQL
8 votes172 views3 answers
Postgres connection string
SQL