Delete all but top n from database table in SQL

by 
DELETE FROM Table WHERE ID NOT IN (SELECT TOP 10 ID FROM Table)

Edit:

Chris brings up a good performance hit since the TOP 10 query would be run for each row. If this is a one time thing, then it may not be as big of a deal, but if it is a common thing, then I did look closer at it.

More Related Contents:

  1. SQL is null and = null [duplicate]
  2. Aggregate columns with additional (distinct) filters
  3. Reset identity seed after deleting records in SQL Server
  4. How to avoid the “divide by zero” error in SQL?
  5. SQLite Reset Primary Key Field
  6. Using an ORM or plain SQL? [closed]
  7. Insert data in 3 tables at a time using Postgres
  8. Better techniques for trimming leading zeros in SQL Server?
  9. Fulltext Search with InnoDB
  10. How to declare variable and use it in the same Oracle SQL script?
  11. List of special characters for SQL LIKE clause
  12. Dynamic SELECT TOP @var In SQL Server
  13. Laravel Eloquent: sum with groupBy
  14. Are a CASE statement and a DECODE equivalent?
  15. Can you access the auto increment value in MySQL within one statement?
  16. Generate script in SQL Server Management Studio
  17. In SQL, is UPDATE always faster than DELETE+INSERT?
  18. MySQL #1140 – Mixing of GROUP columns
  19. How to calculate Session and Session duration in Firebase Analytics raw data?
  20. SQL insert into database with apostrophe
  21. unpivot with dynamic columns plus column names
  22. sql sum data from multiple tables
  23. Creating temporary tables in SQL
  24. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  25. What is the difference between a stored procedure and a view?
  26. DB2 Query to retrieve all table names for a given schema
  27. SQL Convert Week Number to Date (dd/MM)
  28. SQL Unpivot multiple columns Data
  29. ORACLE After update trigger: solving ORA-04091 mutating table error
  30. Foreign Key Not Populating with Primary Key Values

Leave a Comment