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 vote296 views1 answer
Nueva tabla mysql
SQL
0 vote319 views1 answer
Tsql delete all rows
SQL
0 vote320 views1 answer
Insert set mysql
SQL
0 vote311 views1 answer
Replace content value from old to new sql
SQL
0 vote325 views1 answer
Postgres get database encoding
SQL
0 vote349 views1 answer
How to check rollback status in oracle
SQL
0 vote318 views1 answer
Flush user resource mysql
SQL
3 votes306 views4 answers
Show databases in sql server
SQL
2 votes335 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote313 views1 answer
What alter does in db
SQL