MySQL - How to select a specific row by order?

In a MySQL table, you want to select the n-th row by the default order:

SELECT
    *
FROM
    table_name
LIMIT 1 OFFSET n-1;

If you want to select the n-th row after sorting by a column:

SELECT
    *
FROM
    table_name
ORDER BY
    column_name ASC
LIMIT 1 OFFSET n-1;

---

Need a good GUI Tool for MySQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.


Download TablePlus free.