When would you use ORDER BY in DELETE statement?

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

Leave a Reply

Your email address will not be published. Required fields are marked *