How to simulate the LIMIT MySQL clause with an Access database?

MySQLMySQLi Database

In Microsoft Access, you can use TOP instead of LIMIT. Let us first create a −

Insert some records in the table using insert command −

Following is the query to simulate the LIMIT MySQL clause with an Access database −

After clicking Run, you will get the desired output −

In MySQL, to get top 5 values, you need to use LIMIT 5 −

raja
Published on 12-Nov-2019 06:18:00
Advertisements