0 Replies Latest reply on Apr 18, 2013 6:27 AM by Sk Safi

    Rank Function

    Sk Safi

      Hi All,

       

      We are facing a problem on rank function in below scenario :

       

       

      Emp No                          Country                       City

       

      1001                                   X                              A

       

      1001                                   X                               B

       

      1001                                   X                               C

       

      1002                                    Y                              D

       

       

      No we want to take Rank for Emp No 1001 as 1 and for 1002 as 2

      Below should be the Emp No wise Rank

       

      Emp No                          Country                       City        Rank

       

      1001                                   X                              A               1

       

      1001                                   X                               B               1

       

      1001                                   X                               C               1

       

      1002                                    Y                              D               2

       

      Can anyone give some light on the above requirment ?

       

       

       

      Thanks,

      Safi