Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

remove data from SQL table - SQL 2008 R2

A user has added approx 5000 incorrect entries into a DB. I would like to remove them.
Lets assume there are 2 columns in this table-
Serial number and Reference number.

Lets assume the incorrect serial numbers are all between 10000 and 15000.
How do I remove them?

I am not an SQL expert, so would appreciate if you can paste the query I need to run.  
0
Mayogroup
Asked:
Mayogroup
2 Solutions
 
EyalCommented:
delete from tablename where serial >= 10000 and serial <=15000
0
 
mimran18Commented:
Delete from tablename where [serial Number] between 10000 and 15000
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now