Tag: LIMIT

How to select Top 5 records from a table in MySQL?

AbundantCode 4 months ago in MySQL 0

Assume that you have a scenario where you need to retrieve the only the top 5 rows who has the maximum salary from the Employees table. The column name is salary and the table name is Employees. How to select Top 5 records from a table in MySQL? To retrieve the Top 5 employees with maximum salary, order the records by descending order by salary…