Thursday, July 9, 2015

When would you use ORDER BY in DELETE statement?


When you’re 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.

No comments: