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 vote160 views1 answer
Ver usuarios mysql
SQL
0 vote149 views1 answer
10000000000000000000 am to meters
SQL
0 vote162 views1 answer
How to query all tables mysql at the same time
SQL
0 vote164 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote164 views1 answer
T-SQL Never ending DELETE
SQL
0 vote184 views1 answer
Get only structure database mysql
SQL
0 vote161 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote151 views1 answer
C# add a textbox in mysql select
SQL
0 vote165 views1 answer
Mysql group by range
SQL
3 votes150 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL