# 1894 SQL TOP Clause Not Working Properly with Sub-SELECTs

---

I am try to delete X number of bottom rows in a table. So I do a select that gets the Ascending top 10 rows. Then using that select do a delete where the ID are in the select results. The problem is that regardless what if I use ASC or DESC it always deletes the newest rows (highest ID's) instead. I want it to always be the (smallest ID's).