Hi I prefer this syntax:

WITH ItemsToBeDeleted

AS

(

SELECT *

, row_number() over (partition by item_no ORDER BY id) as RowNumber

FROM item_store

)

DELETE FROM ItemsToBeDeleted Where RowNumber = 2

Much more efficient.

Regards,

JP