<p>I have a SQL table with news stories and Unix timestamps. I'd like to only keep the 50 newest stories. How would I write an SQL statement to delete any amount of older stories?</p>

Blockquote
```
```
delete from table where id not in (
    select id from table 
    order by id desc 
    limit 50
)
```
```
You select the ids of the data you don't want to delete, and the you delete everything NOT IN these value...