When would you use ORDER BY in DELETE statement?

Question

Hello
When would you use ORDER BY in DELETE statement?
please reply me. i am waiting for your reply.
Thanx

Answer 1

When you’re not deleting by row ID. Such as in DELETE FROM techinterviews_com_questions ORDER BY timestamp LIMIT 1. This will delete the most recently posted question in the table techinterviews_com_questions.