2 Replies Latest reply: Nov 9, 2014 7:11 AM by geetika kukreja RSS

    to calculate rank (need replacement of over partition by )

      Hi,

      I have ID, Year, Country, Value in my table. I have to calculate rank for country for each ID and Year based on the value in script. More the value, best the rank.

      For example, for year=2014, ID=1, I have value for 20 countries. I need ranking for them (so rank is from 1 to 20)

      Similarly , I have more IDs for the same year, for which the rank should again start from 1.


      Please suggest solution.

      Thanks