ROWS operates on physical row positions. RANGE operates on the logical value of the ORDER BY column. With duplicate values, RANGE treats all rows with the same value as part of the same frame position.