/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 vote219 views1 answer
Oracle sql all days except weekends
SQL
0 vote163 views3 answers
How to assign custom id in mysql
SQL
0 vote192 views2 answers
Cascade syntax in sql
SQL
0 vote170 views1 answer
Oracle list user locked
SQL
1 vote152 views1 answer
How to select rows with no matching entry in another table?
SQL
23 votes155 views1 answer
How remove column in mysql
SQL
1 vote116 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote152 views1 answer
Power query datetime to date
SQL
2 votes132 views1 answer
Mysql list users on ubuntu
SQL
0 vote244 views1 answer
Mysql select field if condition
SQL

Share