C
C
CryptoPython2018-10-19 11:48:08
SQL
CryptoPython, 2018-10-19 11:48:08

How to delete all rows with different ids from 1 table in mssql in 1 query?

In general, the task is this, there are 100id somewhere in 10000 rows, I need to delete 30id, is it possible to somehow delete in 1 request, for example, from 70 - 100 id, something like delete * from table where id = 70 to 100.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
idShura, 2018-10-19
@KryptoPython

I didn't quite understand the question.

delete * from table where id between 70 and  100
--или
delete * from table where id >= 70 and  id =< 100

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question