/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

11 votes290 views3 answers
How to get last row of table in sql
SQL
0 vote306 views1 answer
Delete hangfire retries list
SQL
0 vote259 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote245 views1 answer
Sqlite3 not commit
SQL
0 vote312 views1 answer
Stratified sampling sql
SQL
3 votes269 views3 answers
Concatenation in sql
SQL
1 vote260 views1 answer
Sql injection
SQL
0 vote273 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
3 votes274 views3 answers
List columns in table postgres
SQL
0 vote271 views1 answer
Empty table sqlite
SQL

Share