How to make a request to delete the required values?

Question

SQL Server

Table HES, column itemno, in itemnonumbers from 1 to 600000. How to delete rows containing from 40000 to 40500 in itemno?

Answer 1

"I need a query that will delete all cells ..."
If you meant delete records (not cells), then here:

DELETE FROM HES WHERE (itemno >=40000) AND (itemno <= 40500);