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:
Post a Comment