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 vote408 views1 answer
Mariadb disable foreign key checks
SQL
0 vote342 views1 answer
MySql get primary keys of table
SQL
0 vote333 views1 answer
Stuff in sql server
SQL
14 votes370 views1 answer
Oracle alter table add column not null
SQL
2 votes432 views5 answers
Tablespace ORACLE
SQL
0 vote330 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote364 views1 answer
Microsoft sql server python connection
SQL
0 vote355 views1 answer
Narural join
SQL
4 votes329 views1 answer
Wilayah indonesia database
SQL
2 votes369 views2 answers
Sql query to copy data from one column to another
SQL