Need SQL to delete range of records

  • Thread starter Thread starter tmb
  • Start date Start date
T

tmb

I'm working on an online access db via a third program that issues raw sql
commands to the db.

I know to delete a single record I can use...

DELETE FROM Orders_db WHERE idOrder = 80

MY QUESTION: Anybody know how I can delete a range of records... like when
idOrder is between two numbers

OR when idOrder is less than some number

thanks for the help
 
Very is you already answered your own question
DELETE FROM Orders_db WHERE idOrder < someNumber
or
DELETE FROM Orders_db WHERE idOrder BETWEEN Number1 AND Number2

Omer
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create Many-to-Many "Linking" or "Relational" table ? 6
Won't let me complete new [Order_item] recordn ?? 1
H E L P - Problem with 'related' table - no new record is created - why ? 2
Run batch queries 3
Linked SQL Tables don't report Cascading Updates and Deletes 2
Writing SQL code to delete duplicate records 0
DELETE FROM a table WHERE... 1
Record insert/delete anomaly 0

Back
Top