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 votes188 views2 answers
To_char oracle
SQL
2 votes186 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote237 views1 answer
Stop and start mysql
SQL
0 vote248 views1 answer
Original Query
SQL
-1 vote205 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote200 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
6 votes194 views3 answers
How to delete table sqlite
SQL
5 votes179 views1 answer
Sql first day of current year
SQL
3 votes204 views1 answer
Oracle get trigger ddl
SQL
0 vote159 views1 answer
Update set with join pl sql
SQL