/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 vote274 views1 answer
Restart serial number for postgres
SQL
0 vote194 views1 answer
How to output a different column name in mysql
SQL
1 vote204 views1 answer
Timestamp in sqlite
SQL
1 vote205 views1 answer
Oracle apex run 404
SQL
0 vote213 views1 answer
What does leave do in mysql
SQL
0 vote240 views3 answers
Convert sql query to python pandas
SQL
0 vote202 views1 answer
Postgres where
SQL
4 votes221 views1 answer
For loop postgresql
SQL
0 vote200 views1 answer
Sql reverse order of results
SQL
1 vote196 views3 answers
Union in sql
SQL

Share