Sorting and Limiting Results in MySQL

Published on: July 26, 2025 | Published by: Sai Sreeram Gundepudi

ORDER BY

SELECT * FROM employees ORDER BY salary DESC;

LIMIT

SELECT * FROM employees LIMIT 5;

Aliases

SELECT name AS employee_name FROM employees;