mysql - How to show an specific number of rows based on starter point -

mysql - How to show an specific number of rows based on starter point -

i need show lastly 50 rows of table without using "order desc" cause of ordering. example: if next query

mysqli_query("select * table order id desc limit 50");

i'll lastly 50 rows, wanted obtain but, problem here is, if echo rows, start lastly id , on.

that's why i'm guessing starter point solution. time.

delete chat_table id in ( select id ( select id chat_table order time desc limit 50) temptbl );

mysql sql