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;

Learn more about the similar topics:
No Content Found.
Exercises & Assignments
No Content Found.
Interview Questions & Answers
No Content Found.