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

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: 2019-11-12T06:19:10+05:30

696 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements