Skip to Main Content

duplicate rank()

607061Nov 6 2007 — edited Sep 8 2008
i 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..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Oct 6 2008
Added on Nov 6 2007
10 comments
6,458 views