what do you mean by check values in total income?? you have column total column there right??
if i understand it right, you do another rank for total income..
Rank() over (partition by APPCnum order by total_income desc) as [total income rank]
Hope it Helps!!
No comments:
Post a Comment