SQL Delete query...How do I delete multiple rows from 2 columns?

Question

eg. delete employees with manager number 1 and 2?

is it delete from EMP

where man = '1' and '2'

??

thank you

Answer 1

It depends on what you mean - can one employee have both manager 1 and 2? If so, then that's correct.

If not, then you should be using 'OR'.

Answer 2

a better solution is

delete from emp where man in (1,2)

using this, you can continue the numbering if you like without so much typing.

eg "delete from emp where man in (1,24,56,78,901)" would select the rows where the value of the man column is one of the values between the brackets.. If you're using non-numerical values, don't forget to encase each in single quotes.

Answer 3

No.

Its man = '1' OR man = '2'

Otherwise man would have to be equal to both 1 and 2, which is impossible.