Hi

I'm not sure if you need to do a join on the personel tale but you can use a rank function

RANK ( ) OVER ( [ partition_by_clause ] order_by_clause...