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 −