how to delete one or more rows in table in sql server. For example, I want to say delete from productid WHERE product = 1 to 5. Please tell me, can we delete the raws according to that. An other example, I have 200 raws, but I want to delete from 150 until 200 raws. How can we do that? thanks in advance