Forum : When would you use ORDER BY in DELETE statement?
Brief description about Online courses   join in Online courses
Home News Viewpoint
Travel Entertainment Auto Gadgets & Electronics Sports Lifestyle Food
Rankings Whitepapers Blogs Conferences About Us
View Manju S Reddy 's Profile

When would you use ORDER BY in DELETE statement?

When would you use ORDER BY in DELETE statement?
Asked by Manju S Reddy | Mar 18, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
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.
Mar 18, 2010

Forum By Category