When someone is trying to keep Stack Overflow's answers in check, but OP already copied and pasted the code into his script.

Content

3 RANK() over (partition by Employeecol, Productcol, SalesDatecol order by Quantitycol ASC) share improve this answer answered Mar 25 '14 at 16:12 skc 2 31 02 Did you read what the OP said about its try with rank? If yes, you should elaborate and explain why your answer is a good one. - manuell Mar 25 14 at 17:19 1 Manuell, silence. This is answer was exactly what I was looking for.. you provided nothing. SKC word! - Proximo Apr 29 '14 at 2:43 add a comment