Leave only the first 50 records in the SQL database and delete the rest

Question

I have a grades table, which consists of two fields: name and high score. Something like that:

----------------------- 
| name     | score    |
-----------------------
| John     | 2450     |
-----------------------
| Alice    | 2420     |
-----------------------
                         ... etc    

I need to delete all rows to the 50 best results.

Is it possible to create another temporary table?

Answer 1

try it

delete from scores_tbl Where
id not in
(select * from
(select id from scores_tbl order by score desc limit 50)
 as temp)

Answer 2

Create an auto-increment field

alter table scores add id int unique auto_increment not null;

This will automatically write your lines in the order you select the request without conditions or order

select * scores;
delete from scores where id > 50;

Finally, delete this field.

alter table scores drop id;

Answer 3

, .

: id int auto_increment null;

remove from ratings where id> 50;

change the column name of a table column,