Delete all records from table except sql

Delete all records from table

DELETE FROM table_name;

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

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

Similar codes

0 vote181 views1 answer
How to get employee having maximum experience in mysql
SQL
8 votes198 views1 answer
Oracle add auto_increment column to existing table
SQL
6 votes202 views1 answer
Oracle rank
SQL
10 votes199 views4 answers
Drop primary key
SQL
244 votes500 views14 answers
Sql n insert
SQL
0 vote200 views1 answer
Drop procedure sql
SQL
0 vote231 views1 answer
Mysql where in maintain order
SQL
103 votes2.5K views1 answer
Like sql
SQL
17 votes215 views3 answers
Postgresql version command
SQL
0 vote217 views3 answers
Sql drop all tables
SQL