how to take recent row without limit in mysql code example

Example 1: how to take recent row without limit in mysql

SELECT * FROM (
    SELECT * FROM table ORDER BY id DESC LIMIT 50
) sub
ORDER BY id ASC

Example 2: how to take recent row without limit in mysql

mysql> select *from DemoTable -> where Id=(select max(Id) from DemoTable);