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

11 votes85 views1 answer
Reset identity sql server
SQL
0 vote146 views1 answer
Mssql + bit + in python orm
SQL
2 votes126 views1 answer
Oracle find constraints referencing a table
SQL
2 votes126 views2 answers
Oracle no data found error code
SQL
1 vote132 views1 answer
Sql where max date
SQL
0 vote123 views1 answer
Mysql show category once count how many products
SQL
44 votes246 views4 answers
Mysql alter table add column first
SQL
0 vote131 views1 answer
Get current date data in mysql
SQL
0 vote125 views1 answer
Oracle search columns in schema
SQL
0 vote153 views1 answer
How to change mysql port in xampp
SQL