Can Top clause be used in MySQL?

Question

Can I use the Top clause in the MYSQL instead of the Limit clause?

SELECT TOP 3 * FROM Customers;

phpMyAdmin is not a database, it is a tool to access your database. Remember, MySQL is your database. — tadman, Dec 13 '20 at 12:02

score 2 · Answer 1 · answered Dec 13 '20 at 12:03

Whenever you're wondering if something is supported, the documentation can usually explain.

In this case TOP is not supported by the MySQL dialect. The MySQL way of expressing that is:

SELECT * FROM Customers LIMIT 3;

There is no simple alternative to the LIMIT clause.

1 Answers1