col1 100 100 200 200 300 400 400 400 using partition By col1 get the rank col1 rank 100 1 100 1 200 1 200 1 300 1 400 1 400 1 400 1 I am telling him if we use partition by we will get like this only b...read more