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

2 votes194 views1 answer
Mysql change data type of column
SQL
0 vote187 views1 answer
Sql server convert date to weekday
SQL
1 vote181 views1 answer
Importance of comment in mysql
SQL
1 vote239 views1 answer
Oracle drop chain step
SQL
18 votes213 views3 answers
Mysql add column default value
SQL
0 vote213 views1 answer
How to access to mysql without root
SQL
0 vote185 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
4 votes205 views3 answers
Mysql modify foreign key
SQL
3 votes240 views2 answers
How to View column names of a table in SQL
SQL
0 vote186 views1 answer
Sql insert tuple
SQL