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

1 vote122 views1 answer
Mysql show table character set
SQL
7 votes124 views5 answers
Oracle alter table
SQL
22 votes158 views1 answer
Mysql workbench
SQL
10 votes128 views2 answers
Mysql alter add foreign key
SQL
3 votes250 views6 answers
Sql unique select
SQL
0 vote132 views1 answer
Oracle string substitution
SQL
0 vote143 views1 answer
Rails sql query converstion
SQL
3 votes195 views1 answer
Sql add two values together
SQL
8 votes152 views1 answer
Mysql dump restore
SQL
0 vote121 views1 answer
Oracle grant create job
SQL