How to DELETE in SQL with multiple conditions

Question

I have a table with one column called name_of, I have a lot of duplicates in this table, I have some python code, that takes all the duplicates and then concat them into the SQL query. But I have tried for some time with no luck.

TableName = users_from_group

Column = name_of

i have tried the following sql query:

DELETE FROM users_from_group
WHERE name_of = ('AskeMeyer'), ('testuser'), ('AskeMeyer'), ('testuser'), ('testuser'), ('AskeMeyer')

and I don't understand why this is not working, as this is the format of data for querying adding into the table?

A [mcvce] is a great start when asking SQL questions. We still don't know if you want to delete all duplicates, or if you want to keep one instance of each. (Which one?) — jarlh
– jarlh, Commented Feb 23, 2022 at 15:19
Add a unique constraint to your table, to avoid similar mishaps in the future. — jarlh
– jarlh, Commented Feb 23, 2022 at 15:21

Maximiliano Garcia · Accepted Answer · 2022-02-23 14:03:18Z

1

the best way to do this is:

DELETE FROM users_from_group
WHERE name_of IN ('AskeMeyer', 'testuser', 'AskeMeyer', 'testuser', 'testuser', 'AskeMeyer')

If this is useful for you, I would appreciate to mark as resolved. Cheers

answered Feb 23, 2022 at 14:03

Maximiliano Garcia

342 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jarlh Over a year ago

Why repeat values?

FallenA Over a year ago

@jarlh it is duplicates found from the python code

Cargo23 · Accepted Answer · 2022-02-23 14:10:26Z

1

As @jarlh mentioned, you probably don't want to delete ALL of the records with these name_of's. I'm guessing you want to keep exactly 1 of each?

The best practice for this scenario is to do your work all in SQL, following a "Delete Duplicate Rows" pattern. There are a couple ways to do this, and it can matter which version of SQL you are using, but this question is a starting point.

Also, just a couple S/O tips:

Include which SQL server you are using in your questions in the future
Include the error message that you receive

answered Feb 23, 2022 at 14:10

Cargo23

3,18918 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to DELETE in SQL with multiple conditions

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related