duplicate rank()
607061Nov 6 2007 — edited Sep 8 2008i output like this :
date code oil rank
Jan-07 a01 10 1
Jan-07 a03 5 2
Jan-07 a04 4 3
Jan-07 a05 23 4
Jan-07 a06 3 5
Feb-07 a01 25 1
Feb-07 a02 32 2
Feb-07 a03 42 3
Feb-07 a04 33 4
Feb-07 a05 52 5
Feb-07 a06 11 6
i want code a02 include altought in other month there is no code a02:
date code oil rank
Jan-07 a01 10 1
Jan-07 a02 0 2
Jan-07 a03 5 3
Jan-07 a04 4 4
Jan-07 a05 23 5
Jan-07 a06 3 6
Feb-07 a01 25 1
Feb-07 a02 32 2
Feb-07 a03 42 3
Feb-07 a04 33 4
Feb-07 a05 52 5
Feb-07 a06 11 6
and i would like high performance
thank you for your attention..