Removing column values ​​from number to number?

Question

SQL Server

The accounts table and it also has columns: accountID and userName:

<b>userName       accountID</b>
Alan               1000
Josef               1001
Josef               1002
Josef               1003
Josef               1004
Josef               1005

How to write a query that would delete accounts with accountID from 1001 to 1005

Answer 1

Elementary:

delete from users where accountID between 1001 and 1005;

MS SQL fiddle