/SQL/Sql delete all except

Sql delete all except

Delete all records from table except sql

DELETE FROM my_table WHERE col1 > 2;
DELETE FROM my_table WHERE col1 IS NOT NULL;

0

Delete all records from table except sql

delete from yourTableName where yourColumnName NOT
IN(‘yourValue1’,‘yourValue2’,‘yourValue3’,.........N);

0

Sql delete all except

DELETE FROM Pessoa
WHERE ID = 12

0

Similar codes

0 vote121 views1 answer
Sql server get date of previous sunday
SQL
5 votes143 views1 answer
Oracle get ddl
SQL
0 vote115 views1 answer
Deny select insert update delete sql
SQL
3 votes123 views1 answer
Oracle rollback
SQL
11 votes129 views2 answers
Insert current date sql
SQL
0 vote194 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote127 views1 answer
Mysql in clausule string array
SQL
0 vote121 views1 answer
Sql composite key
SQL
2 votes83 views1 answer
Sql float to int
SQL
5 votes119 views1 answer
Mysql select greater than yesterday
SQL

Share