When would you use ORDER BY in DELETE statement?

Question

Anonymous User · Answer

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

interview

When would you use ORDER BY in DELETE statement?

Can you answer this question?

1 Answers