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

3 votes210 views1 answer
Set default today mysql
SQL
0 vote202 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
6 votes210 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote199 views1 answer
Sql database size
SQL
0 vote222 views3 answers
Join
SQL
1 vote201 views1 answer
Psql connect to another database
SQL
0 vote199 views1 answer
What is mysql_pconnect
SQL
1 vote211 views1 answer
Psql lst trigger
SQL
0 vote214 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote227 views1 answer
Sql out file formate
SQL