Home > DeveloperSection > Interviews > When would you use ORDER BY in DELETE statement?

Posted on    April-09-2012 9:04 AM

 1 Answer(s)
  1631  View(s)
Rate this:

Arun Singh

Total Post:310

Posted on    April-09-2012 12:00 AM

When are you 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.

Don't want to miss updates? Please click the below button!

Follow MindStick