Discussion board
When would you use ORDER BY in DELETE statement?
By Manju S Reddy
When would you use ORDER BY in DELETE statement?
Reply
Post   Reset
Teacher SiliconIndia replied to Manju S Reddy Thursday, March 18, 2010
Hi Manjunath,
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.