[sql] How to delete from a table where ID is in a list of IDs?

if I have a list of IDs (1,4,6,7) and a db table where I want to delete all records where ID is in this list, what is the way to do that?

This question is related to sql database-design

The answer is


delete from t
where id in (1, 4, 6, 7)