| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
05-11-2007, 07:49 PM
|
|||
|
|||
ANY dialect question:
delete from table where column != (multiple values)Have a table with around 700 rows. I want to delete all but around 30. How can I specify multiple different values for a given column to not delete. I'm thinking something like:
DELETE * FROM TABLE WHERE COLUMN != ('valueA','valueB','valueC'...'valueN')but I mustn't have the syntax correct because I keep getting errors. TIA, Dan     
|
