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

28 votes197 views6 answers
Mysql change user password
SQL
6 votes200 views3 answers
Update with inner join postgres
SQL
0 vote195 views2 answers
Mysql update two tables at once
SQL
0 vote205 views1 answer
Mysql workbench procedure
SQL
0 vote198 views2 answers
How to count codition
SQL
0 vote208 views1 answer
Test database for sql
SQL
2 votes194 views1 answer
Oracle sql day of month from date
SQL
0 vote213 views1 answer
Add mysql database to power bi web
SQL
0 vote236 views1 answer
Search In the Data using ObjectName
SQL
7 votes189 views1 answer
Sql management studio display line numbers
SQL