Comment by sapling

Sorry I am wrong.I saw the PARTITION BY {column name} and lazy me assumed things.