Postgresql delete multiple rows

If you have to select the id:

 DELETE FROM table WHERE id IN (SELECT id FROM somewhere_else)

If you already know them (and they are not in the thousands):

 DELETE FROM table WHERE id IN (?,?,?,?,?,?,?,?)

Source: stackoverflow.com

Similar codes

3 votes223 views1 answer
Unsigned int in mysql
SQL
0 vote222 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote223 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote206 views1 answer
C# datetime to sql server datetime
SQL
1 vote210 views2 answers
Oracle list partitioned tables
SQL
2 votes261 views1 answer
Python sql
SQL
12 votes222 views4 answers
Mysql get date difference in hours
SQL
1 vote206 views1 answer
Funzioni plsql
SQL
0 vote231 views2 answers
Pop sql insert value into
SQL
0 vote210 views1 answer
Sql select all records from all tables where not empty
SQL