What is the command to delete the rows where id is between 20 and 100 in the table Person?

Wha开发者_运维知识库t is the command to delete the rows where id is between 20 and 100 in the table Person?

I know BETWEEN is involved.

DELETE FROM Person WHERE id BETWEEN 20 AND 100

You were almost there! See the documentation here.