How to simulate the LIMIT MySQL clause with an Access 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 −

Updated on: 12-Nov-2019

543 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements