TOP CATEGORIES

×

How to DELETE multiple rows in SQL?

V

Vedika

In SQL, There are multiple ways to DELETE multiple rows, Such as:

1st Query

DELETE FROM table_name

WHERE id IN (no.1, no.2); OR

2nd Query

DELETE FROM table_name

WHERE id IN (value1, value2, ...);

3rd Query

DELETE FROM table_name

WHERE id IN (SELECT * FROM table WHERE id = );

4th Query

DELETE FROM table_name

WHERE id BETWEEN bottom_value AND top_value;

1 votes

Your Answer

Email: advertise@gdatamart.com

Donate: To Support US

© 2024 GDATAMART.COM (All Rights Reserved)