sql - Is there an alternative to TOP in MySQL?

Question

I want to know the alternative of the TOP keyword as in MySQL. I have read about TOP in SQL Server.

Is there any alternative to this in MySQL, or any other method in MySQL from which we can get same functionality?

Answer 1

Ordering and limiting the results:

SELECT field1, field2
FROM myTable
ORDER BY field1 ASC
LIMIT 10