how do I delete from table after sorting? MySQL

[lli2k5]

Say if I want to sort column X from largest to smallest, but I want to delete all the entries from all rows after the 25th place. how can I do this?

[NogDog]

Are you talking about physically deleting them from the database, or just limiting the number of rows returned by a select query?

[lli2k5]

physically deleting them from the database. Like the delete function but applying after sorting.

[NogDog]

Perhaps something like this?

DELETE FROM table_name WHERE key_column NOT IN 
(SELECT key_column FROM table_name ORDER BY column_X DESC LIMIT 25);

[lli2k5]

solved. Got it.