How to delete multiple rows in SQL where id x to y

Question

I am trying to run a SQL query to delete rows with id s 163 to 265 in a table  I tried this to delete less number of rows      DELETE FROM  table  WHERE id IN  264  265    But when it comes to delete 100 s of rows at a time  Is there any query similar to above method I am also trying to use this kind of query but failed to execute it      DELETE FROM  table  WHERE id IN  SELECT   FROM table WHERE id       Please tell me the query to do the above action

User · Answer

CREATE PROC  dbo   sp DELETE MULTI ROW          CODE XML   ERRFLAG  CHAR 1     0  OUTPUT      AS          SET NOCOUNT ON   SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED    DELETE tb SampleTest     WHERE          CODE IN              SELECT Item value       VARCHAR 20                FROM   CODE nodes  RecordList ID   AS x Item                 IF   ROWCOUNT   0     SET  ERRFLAG   200  SET NOCOUNT OFF   Get string value delete   lt RecordList gt       lt ID gt 1 lt  ID gt       lt ID gt 2 lt  ID gt   lt  RecordList gt

User · Answer

If you need to delete based on a list  you can use IN   DELETE FROM your table WHERE id IN  value1  value2          If you need to delete based on the result of a query  you can also use IN   DELETE FROM your table WHERE id IN  select aColumn from          Notice that the subquery must return only one column   If you need to delete based on a range of values  either you use BETWEEN or you use inequalities   DELETE FROM your table WHERE id BETWEEN bottom value AND top value    or  DELETE FROM your table WHERE id  gt   a value AND id  lt   another value

User · Answer

Please try this   DELETE FROM  table  WHERE id  gt  163 and id lt   265

User · Answer

You can use BETWEEN   DELETE FROM table where id between 163 and 265

User · Answer

Delete Id from table where Id in  select id from table

[sql] How to delete multiple rows in SQL where id = (x to y)

Examples related to sql

Examples related to sql-delete