# DELETE/LIMIT problem

**URL:** <https://forum.kirupa.com/t/delete-limit-problem/283763>\
**Category:** programming\
**Created:** [March 10, 2009, 9:16pm UTC](https://forum.kirupa.com/t/delete-limit-problem/283763 "2009-03-10T21:16:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hommer](https://avatars.discourse-cdn.com/v4/letter/h/a3d4f5/32.png) [@Hommer](https://forum.kirupa.com/u/Hommer)\
**Post date:** [March 10, 2009, 9:16pm UTC](https://forum.kirupa.com/t/delete-limit-problem/283763/1 "2009-03-10T21:16:42Z")

</div>

I have a highscore table in MySQL. I want to delete all players below the 10’th place.  
I thought this should do it, but I’m having problems:

```auto
DELETE FROM highScores WHERE ID = (SELECT ID FROM highScores ORDER BY score DESC LIMIT 10, 9999);

```

When I run the command I get this error:  
[COLOR=“DarkRed”]#1093 - You can’t specify target table ‘highScores’ for update in FROM clause[/COLOR]

Can someone see the problem and tell me how the code should look?

Thanks guys.