How to select Top 10 records in MySQL?

You can use “LIMIT” to restrict a number of records and “ORDER BY” to sort according to the specific column name.

select * from students ORDER BY student_id LIMIT 10;

• Previous Interview Question
• Next Interview Question

---

Tutorials
No Content Found.

Exercises & Assignments
No Content Found.

Interview Questions & Answers
No Content Found.