Answers for "mysql limit 1 for last record"

SQL
0

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
Posted by: Guest on April-01-2021
0

how to take recent row without limit in mysql

mysql> select *from DemoTable -> where Id=(select max(Id) from DemoTable);
Posted by: Guest on April-01-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language